Menu problem

[werred]

I have the following problem. I want to make a two-dimensions menu (user clicks on a category and under it appears list of subcategories of this category). The problem is that I can't display the subcategories right under the selected category - it displays under the whole block of categories. How can I solve the problem?

Here is my code:

function ShowCats() {
$cat=mysql_query("SELECT * FROM category ORDER by orderlist") or die ("Cant: " . mysql_error());
while($rows=mysql_fetch_array($cat)) {
echo "<a class='categorie' href='index.php?go=products&catid=$rows[id]'>$rows[name]</a>";
}
if(isset($catid)) {
$subcat=mysql_query("SELECT * FROM subcategory WHERE category=$catid ORDER BY orderlist");
while($rows=mysql_fetch_array($subcat)) {
echo $rows['name'];
}
} 

Thanks a lot.

[NightShift58]

I'm not sure where $catid is coming from, but assuming it's "there", this could be what you're looking for...

<?php
function ShowCats() {
  $cat=mysql_query("SELECT * FROM category ORDER by orderlist") or die ("Cant: " . mysql_error());

  WHILE ($cat_rows=mysql_fetch_array($cat)) :
    echo "<a class='categorie' href='index.php?go=products&catid=" . $cat_rows['id']. "'>" . $cat_rows['name'] . "</a>";
    IF (isset($catid) AND $catid == $cat_row['id']) :
      $subcat=mysql_query("SELECT * FROM subcategory WHERE category=$catid ORDER BY orderlist");
      WHILE ($sub_rows=mysql_fetch_array($subcat)) :
        echo $sub_rows['name'];
      ENDWHILE;
    ENDIF;
  ENDWHILE;
}
?>

[werred]

NightShift58, your script doesn't show the subcategories at all.
The $catid variable is set when a user clicks on a category. Any other thoughts about how to tell the script to open the subcategory list?