Write Forums

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;

No comments posted yet

170 51 Tweet

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Sharing PHP Sessions Across Domains 
I am in the process of writing a script to share a php session across various domains I have.
The
Need help with unexpected T-STRING error 
I'm a newbie and I'm still learning PHP. However this error has me stumped. I've googled, searched t
Can you help please? Php file 
I have to write this php file to allow users to register their nicknames on nickserv

For an I
Weird problem with SELECT command..Help! 
Hi!

It seems I'm having a really weird problem with SQL SELECT command....I have table into a
Vertical Alligning - Not working in 1 cell? 
<?php

echo "<table id="valign" width="60%" style=
Does design fit in FPGA ? 
Hi all,

I've made a large HCC-Design. Because of the program-size the compile process with th
Strange  HTML Tag? 
I recently noticed some odd HTML appear in some of the websites I host. Not all of them are run on a