How to create a static html menu from a database

Posted on 16th Feb 2014 07:03 pm by admin

Hi,

I have built a small cms which allows me to create simple html pages and then upload them to an ftp.

Everything is working apart from the menu, I cant get my head round how to create the menu system. The outputted file is a static html file that wont be connected to a database, so I need to retrieve the information from the database then write this information in standard html to a page before it is sent to the ftp.

I have looked through the forum and the net and can't find a solution, can anyone help?

CODE//// (which I know is incorrect, but kind of works and should hopefully show what I mean)

$page_name = mysql_query("SELECT * FROM pages WHERE page_display = 'yes' ORDER BY page_order ASC")
or die(mysql_error());


while($info = mysql_fetch_array( $page_name ))
{
$page[] = $info[page_name];
}

$navigation = <<<EOD


<li>$page[0]</li>
<li>$page[1]</li>
<li>$page[2]</li>
<li>$page[3]</li>


EOD;

Your Answer:

Login to answer

Other forums

Help with echo()
I'm having some problems with this code:

Code: echo '
<A HREF="jav

Any Good MMORPGs you've played?
I'm about to have ALOT of free time on my hands (finished highschool) and I need something to fill t

why aint this working?
i have this code:

Code: $num = 250;
$count = ($num - $rcount);

echo $rc

Database 'Validation'
Hi everyone,
I'm trying to validate the password entered by the user with the password in the dat

some questions
Hello,

I am looking for the answers for following questions:

1) Does PHP support overl

Socket programming
Hello all,

I have a PHP socket script. GPS trackers connect to this socket. IMEI verification

Protecting forms
Alright, I want to protect some forms of mine from SQL Injections, because I had someone earlier spa

$get problem
Hi Guys ...

can you please tell me what i am doing wrong here
Code: <?php

Lining up columns nicely.
Hello everyone, I'm having problems with making columns line up properly. Here is my code:

I face problems to extract data from one table and insert it in another one
Hi,

For modifications, I have to extract data from one table and insert it in another one