recursive menus
| From: | electroteque | Date: | Tue, 25 Jun 2002 15:00:20 +0000 |
| Subject: | recursive menus | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-103785@lists.php.net to get a copy of this message | ||
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>";
}