Results 1 to 2 of 2

Thread: Can't seem to figure this out

  1. #1
    Join Date
    Jul 2010
    Location
    Minnesota
    Posts
    256
    Thanks
    1
    Thanked 21 Times in 21 Posts

    Default Can't seem to figure this out

    So I am making a products area and I have a left sidebar that will hold the categories and the brands with in the categories. What I want is the list to only show the main categories until a category is selected then once the page f=refreshes with the GET variable the list will change to show the brands with in the category selected. Now I can get is to show all the brands in the categories but not just the one that is selected. I think I am on the right track with this but just can't seem to get it. Here is a link to the page so you can see the result - http://shootersbilliardclub.com/store.php I am echoing the id's so you can see the numbers as to where they should be in relation to the category numbers and how they are not showing that way.
    PHP Code:

    $_GET
    ['catid'] = mysql_real_escape_string($_GET['catid']);
    $catid $_GET['catid'];

    $get_brands mysql_query("SELECT * FROM prod_brands");
    $brands mysql_fetch_array($get_brands);
        
    $brand_id $brands['brand_id'];
        
    $brand $brands['brand'];
        
    $b_cat_id $brands['b_cat_id'];
        
    $get_cats mysql_query("SELECT * FROM prod_cats");

    echo 
    "<ul class='categories'>";
    while (
    $cats mysql_fetch_array($get_cats))
    {
        
    $prod_cat_id $cats['prod_cat_id'];
        
    $prod_cat_title $cats['prod_cat_title'];
        echo 
    $prod_cat_id;
        
        echo 
    "<a href='store.php?catid=$prod_cat_id'><li>$prod_cat_title</li></a>";
      if (
    $catid)
      {
       if (
    $b_cat_id == $_GET['catid'])
       {
        if (
    $b_cat_id !==0)
            {
              
              while (
    $brands mysql_fetch_array($get_brands))
                {
                
    $brand_id $brands['brand_id'];
                
    $brand $brands['brand'];
                
    $b_cat_id $brands['b_cat_id'];

                echo 
    $b_cat_id;
                echo 
    "<ul><li><a href='b-products.php?b_id=$brand_id'>$brand</a></li></ul>";
                }
                  
            }
            else {}
        }        
      }
      else{}
    }
    echo 
    "</ul>"

  2. #2
    Join Date
    Jul 2010
    Location
    Minnesota
    Posts
    256
    Thanks
    1
    Thanked 21 Times in 21 Posts

    Default

    Figured it out! If anyone has a similar issue and wants to know the code I used to make it work just let me know and I will post it up.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •