# Php list-style menu issues

**URL:** <https://forum.kirupa.com/t/php-list-style-menu-issues/300503>\
**Category:** programming\
**Created:** [November 22, 2009, 5:27pm UTC](https://forum.kirupa.com/t/php-list-style-menu-issues/300503 "2009-11-22T17:27:57Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![drummer392](https://avatars.discourse-cdn.com/v4/letter/d/45deac/32.png) [@drummer392](https://forum.kirupa.com/u/drummer392)\
**Post date:** [November 22, 2009, 5:27pm UTC](https://forum.kirupa.com/t/php-list-style-menu-issues/300503/1 "2009-11-22T17:27:57Z")

</div>

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.

```php

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

```