hi i have been trying to sought out a recursive hierarchical menu populated
from mysql how is this possible ? i have tried this but doesnt work
$result = $db->query("SELECT * FROM mainsection ms LEFT JOIN subsections
ss ON ms.sectionID=ss.mainsectionID ORDER BY ms.sectionID,ss.subsectionID");
while ($menu = $result->fetchRow(DB_FETCHMODE_ASSOC)) {
$section = $menu["section"];
$sectionID = $menu["sectionID"];
$subsection = $menu["subsection"];
$subsectionID = $menu["subsectionID"];
$mainsectionID = $menu["mainsectionID"];
if ($mainsectionID=$sectionID) echo "$section<br>$subsection<BR>"; else
echo "$section<br>";
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
