Php list-style menu issues

programming
1

Hey there,

I have a list menu using PHP with 3 levels. Here is how it is laid out:

Category 1
[INDENT]-Link[/INDENT]
[INDENT]- Subcategory[/INDENT]
[INDENT][INDENT]- Sublink[/INDENT][/INDENT]

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.


# 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>";
}