Hey there,
I have a list menu using PHP with 3 levels. Here is how it is laid out:
Category 1
-Link
- Subcategory
- Sublink
and so on.
The problem I am having is getting a "</ul></li>" to show up after each subcategory and sublinks. I can get it to show up once, but if there is more than 1 subcategory, then it needs to show up after every subcategory.
PHP Code:
# Connect to the database
// Get the categories
$cat_result = mysql_query('SELECT catid, category FROM category;');
// Loop through the categories
while ($category = mysql_fetch_assoc($cat_result))
{
// Write the category header
echo "<li><a href='javascript:blankfunction()'>{$category[category]}</a><ul>";
// Get the pages belonging to the category
$getpages = mysql_query("SELECT * FROM pages WHERE catid={$category[catid]} AND is_cat=0;");
while ($page = mysql_fetch_assoc($getpages))
{
echo "<li><a href='sidepage.php?id={$page[id]}'>{$page[title]}</a></li>";
}
$getsub = mysql_query("SELECT * FROM pages WHERE catid={$category[catid]} AND is_cat=1;");
while ($sub = mysql_fetch_assoc($getsub))
{
echo "<li><a href='javascript:blankfunction()'>{$sub[title]}</a><ul>";
}
$sid = $sub['id'];
$getsubpage = mysql_query("SELECT * FROM subpages WHERE sub_id={$sid};");
while ($subpages = mysql_fetch_assoc($getsubpage))
{
echo "<li><a href='javascript:blankfunction()'>{$subpages[title]}</a></li>";
}
echo "</ul></li>";
}
Php list-style menu issues
Linear Mode
