Hjælp udskrift af menu
HejNogle der kan hjælpe her.
Har en menu hvor der er en submenu og en undermenu til denne.
Jeg skal have lavet en liste hvor den skriver den sådan:
sub1
sub2
sub2_1
sub2_2
sub3
sub4
sub4_1
sub4_2
osv
Min kode skriver den sådan (ovenstående eksempel)
sub1
sub2
sub2_1
sub2_2
sub3
sub4
sub2_1
sub2_2
sub4_1
sub4_2
Min kode er her:
-------------------------------------------------------
<?php
require_once('Connections/db.php');
$sql = "SELECT * FROM menu WHERE menuSubId = 0 ORDER BY menuOrder";
//$sql = "SELECT * FROM menu WHERE menuSubId = 0 ORDER BY menuOrder";
$rsMenu = $db->SelectLimit($sql) or die($db->ErrorMsg());
while (!$rsMenu->EOF) {
$arrMain[] = $rsMenu->Fields('menuId');
$rsMenu->MoveNext();
}
?>
<!-- Top Menu Slut -->
<!-- Submenu 1st Level Start -->
<?php
foreach ($arrMain as $menuId) {
?>
<?
$sql = "SELECT * FROM menu WHERE menuSubId = " . $menuId . " ORDER BY menuOrder";
// $sql = "SELECT * FROM menu WHERE menuSubId = " . $menuId . " ORDER BY menuOrder";
$rsMenu = $db->SelectLimit($sql) or die($db->ErrorMsg());
while (!$rsMenu->EOF) {
if ($rsMenu->Fields('menuHasSub') == 1) {
$arrMenuSub[] = $rsMenu->Fields('menuId');
?>
<table width="100%" height="20" border="0" cellpadding="0" cellspacing="0"><tr><td valign="middle"><?php echo $rsMenu->Fields('menuName')?></td>
</tr>
</table>
<!-- Submenu 2nd Level Start -->
<?php
foreach ($arrMenuSub as $menuId) {
?>
<?
$sql2 = "SELECT * FROM menu WHERE menuSubId = " . $menuId . " ORDER BY menuOrder";
//$sql = "SELECT * FROM menu WHERE menuSubId = " . $menuId . " ORDER BY menuOrder";
$rsMenu = $db->SelectLimit($sql2) or die($db->ErrorMsg());
$int = 0;
while (!$rsMenu->EOF) {
$int = 1;
?>
<table width="100%" height="21" border="0" cellpadding="0" cellspacing="0"><tr><td valign="middle"><?php echo $rsMenu->Fields('menuName')?></td>
</tr>
</table>
<?php
$rsMenu->MoveNext();
}
?>
<?php
}
?>
<!-- Submenu 2nd Level end -->
<?php
} else {
?>
<table width="100%" height="20" border="0" cellpadding="0" cellspacing="0"><tr><td valign="middle"><?php echo $rsMenu->Fields('menuName')?></td>
</tr>
</table>
<?php
}
$rsMenu->MoveNext();
}
?>
</div>
<?php
}
?>
<!-- Submenu 1st Level Slut -->
<br>
<br>
<br>
</body>
</html>
