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

column name cancatenation within PL/SQL
I have a PLSQL store procedure, and the following statement is part of a subquery
fname||lnam

Validating time
Hi Guys

what do you think of the following approach to validate a 24hour time:

http://

ALV List Display to point to another report on Double Click
Hi,

I want my ALV List Display to point to another report on Double Click on its line ite

import table with dependency
Hi

What is the best way to import table back which has dependency?

SQL> cre

'grab_files', multiple extension?
hey guys,

can anyone suggest a way to make to following line of code look for files with more

Why is this query failing?
Why is this not working?
$query = "SELECT * FROM `users` WHERE `userid` = " . $USERID

Stopping page post back
I have few literal contriols in my page and a repeater too. But inspite of using update panel, postb

Need help urgant
why down my code ony return one item instead of all the items selected.

$arr = array($date,$

PHP - MySQL Fail
My PHP code will only execute the first part of my code...

Code: <?php

sessio

Array disappearing in foreach loop
Okay, I have this problem where an array will become undefined in a foreach loop.

Here is the