Help me please!!

[jeremyjcochran]

I'm trying to make an online store and have everything working so far. The only problem I am having is making a multi level navigation. When someone clicks "mens" section it brings up stuff like "tshirt", "hats", etc. That works fine, my problem is when they click on that I want the same sub navigation to be there so they can still look at "tshirt", "hats", etc without having to click "mens" again. I have this code already :

 $catsql = "SELECT * FROM categories2;";
   $catres = mysql_query($catsql);
 
echo "&nbsp;<br>";
 
   while($catrow = mysql_fetch_assoc($catres))
   {
     echo "<a class='" . products . "' href='" . $config_basedir
. "/productchoices.php?id=" . $catrow['id'] . "'>"
. $catrow['name'] . "</a><p class='" . products . "'>";
   }
 
echo "<br>&nbsp;";

The only problem with it, is it lists all the categories (Like girls tshirts, etc) as well. How do I limit it so its only for that specific section.

In the database I have categories, categories2, categories3, and products. Categories are at the top, they are the main ones. A user clicks that and goes to a page with categories 2, which lists the main items specific to that category. Then they choose one and it goes to categories 3, which is a spread of different products for that category. Finally they click on one of the products they like and go to a details page which is the products. I want the categories 2 navigation to work on the categories 3 and products page, so users can easily go back to that section of clothing.

The database has this info stored for each category:

categories: id
                 name
categories2: id
                   cat_id
                   name
categories3: id
                   cat_id
                   name
products:id
             cat_id
             name

I have this code for the categories2 page (Theres a check in there to see if there are any products first, then it lists the main sections if there are):

<?
 
   $prodcatsql = "SELECT * FROM categories2 WHERE
cat_id = " . $_GET['id'] . ";";
   $prodcatres = mysql_query($prodcatsql);
   $numrows = mysql_num_rows($prodcatres);
 
if($numrows == 0)
{
   echo "<p class='" . whiteheader . "'>&nbsp;<br>No Products<br>&nbsp;";
 
 
}
 
else
{
      $catsql = "SELECT * FROM categories2 WHERE
cat_id = " . $_GET['id'] . ";";
   $catres = mysql_query($catsql);
 
   $camsql = "SELECT * FROM categories WHERE
id = " . $_GET['id'] . ";";
   $camres = mysql_query($camsql);
   if($camrow = mysql_fetch_assoc($camres))
{
echo "&nbsp;<br>";
 
   while($catrow = mysql_fetch_assoc($catres))
   {
     echo "<a class='" . products . "' href='" . $config_basedir
. "/productchoices.php?id=" . $catrow['id'] . "'>"
. $catrow['name'] . "</a><p class='" . products . "'>";
   }
}
echo "<br>&nbsp;";
}
?>

I've tried to take this code and use it for categories3, but it doesn't understand to get the id from categories. So it lists all of them instead of the ones specific to that id.

Can anyone help me out? Thank you!!

[Markus]

jeremyjcochran,

When posting code in the forums, it is required that you wrap the code in [code] tags. You can do this by simply highlighting the code and then hitting the '#' button at the top of our editor (where you write your post). Doing this formats your code and, in return, helps our experts read it and give an answer.

If you have any doubts, you can have a look over our Posting Guidelines to get familiar with the rules.

Thanks,
Moderator.