Database driven menu

Superfly

I am new to PHP and I am creating a database driven website using PHP and Mysql. On my website I would like to make the website menus to be database driven as well. This will make it easy to do updates and allow non-programmers to easily make amendments to the menu structure by just updating fields on a database through a customised front-end. This is really important as the web page will have many pages and I want to simplify things as much as possible. I know how to set up CSS list based horizonatal/Vertical menu thanks to the excellent examples on http://css.maxdesign.com.au/listamatic/ , However I don't know how to go about making the menu's to be database driven using PHP and Mysql. I have looked everywhere but I have not been able to find any examples about how this can be done. Does anyone know of any good websites or books that could help be? I am sure this is feasible.

Thanks

Shrike

Do a search on this board, this topic has been raised many times.

gardnc

This will point yoou in te right direction. From the listamatic simple list example:

<div id="navcontainer">
<ul id="navlist">
<?php
// put code here to get menu records from data base

while($rs = mysql_fetch_array($result)) {

echo '<li id="active"><a href="<?php echo $rs["menu-url'] . " id="current">' . $rs["menudescription"] . '</a></li>

}

?>
</ul>

</div>

More or less
Larry

Superfly

Thanks a lot for this code it was really helpful