Menu Troubles

iceman2g

Hi guys i'm working on a drop down menu for the cart program i'm using. I'd like to populate the menu with categories from the database. I've written some code for that but only getting it to work partly.
Here's what i've got:

// create navigation
		require ("link_navi.php");

$sql_select = mysql_query( "SELECT * FROM ".$prefix."store_category where cat_id='$cat_id' order by $cat_order");
	while ($row = mysql_fetch_array($sql_select))
		{
		}
echo "<table border=\"0\" cellspacing=\"2\" width=\"95%\" cellpadding=\"10\" align=\"center\">
		<tr><td align=\"center\">";
		$sql_select = mysql_query( "SELECT * FROM ".$prefix."store_category where cat_father_id = $cat_id order by $cat_order");
         echo"<form name=\"form1\"><select name=\"catergorylist\" onChange=\"go(this)\">";
         echo"<option selected value=\"index.php?cat_id\">Please Select:</option>";
		$more_cat = MYSQL_NUM_ROWS($sql_select);	

	while ($row = mysql_fetch_array($sql_select))
		{
			$cat_id_list = $row["cat_id"];
			$category = $row["category"];

    echo"<option value=\"index.php?cat_id=$cat_id_list&catname='$category' 						\">$category";
				}
    echo"<option>"; { echo"</select></form>";

				{
		}

}
echo"</td></tr></table>";

Now the problem comes when you select that catergory and it forwards you to the catergory page the menu is still present, only in contains nothin but "Please Select". I'd like to not have the menu on the category page once it's selected, if that can't be done then if I can i'd like populate the menu with the catergories of the previous page. Also for some reason I have a empty space at the bottom of the menu.

Any help with this is greatly appreciated.

What might I be missing? Any help is greatly appreciated.

PallaviDalvi

i assume that when u mean , the control is forwarded to category page... u are refering to index.php which is not the file where this piece of code is present. in that case...i dont understand why u are displaying this menu if u dont want it to. but if u mean this same file then in that case try some thing like
if (isset($_REQUEST['cat_id'] )) to decide whether the select has to be displayed or not.
hopefully i understood ur problem correctly... get back if not.

iceman2g

Ok maybe these pictures will better ilustrate.

Here's what I set out to do and accomplished. Notice how the sub categories are being displayed in the drop down menu.

iceman2g

Now notice how once that sub category is selected how it takes you to that page, but the drop down menu is still being displayed, only this time it's empty.

What i'd like to do it populate that empty menu with the items that were on the previous category page. i.e. AMD, INTEL

PallaviDalvi

i think if (isset($_REQUEST['cat_id'] )) shud help u .
if set ...i.e if the cat has been selected once then u do not display the select drop down. else u do.
hope that helps u

PallaviDalvi

ok...if u want to populate the select then u have to re-execute the query ... meaning u have to pass on the values used by query as query string too. i.e u need to pass $cat_order and &cat_id too as part of the query string.

iceman2g

Ok i'm lost i'm really bad as this stuff. This has been my first successful attempt at getting this right i've been trying for the past week now. Forgive me for being slow.

PallaviDalvi

🙂 i know just how u feel... the code u picked up is pretty demanding... just give me soem time... i'll try to whip up a small code to demonstrate what i mean... and then u can tell me what u mean... hope thats fine with u...

iceman2g

That's fine. It's hard for me to actually see the code in my head I have to write it down, otherwise it's just all a jumbled mess.

BTW thank you for all your help.🙂

PallaviDalvi

i assume the piece of code u gave to be in index.php. with effect it means that when the option is selected...the querystring comes to this file itself. now the queries used to populate the select can still be executed if u just change the values of variables...
note the change in querystring passed from option

$sql_select = mysql_query( 'SELECT * FROM '.$prefix.'store_category where cat_id='$cat_id' order by $cat_order'); 
while ($row = mysql_fetch_array($sql_select)) 
{ 

echo "<table border='0' cellspacing='2' width='95%' cellpadding='10' align='center'><tr><td align='center'>"; 
$sql_select = mysql_query( 'SELECT * FROM '.$prefix.'store_category where cat_father_id = $cat_id order by $cat_order'); 
echo "<form name='form1'><select name='catergorylist' onChange='go(this)'>"; 
echo "<option selected >Please Select:</option>"; 
$more_cat = MYSQL_NUM_ROWS($sql_select);     

while ($row = mysql_fetch_array($sql_select)) 
{ 
	$cat_id_list = $row['cat_id']; 
	$category = $row['category']; 

	echo"<option value='index.php?cat_id=" . $cat_id . "&sub_cat=" .$cat_id_list ."'>" .$category ."</option>";  
} 
echo"</select></form>"; 

} 
echo"</td></tr></table>";

using $cat_id u can execute the above query and populate the select. using sub_cat($cat_id_list) u can display the details for selected sub category.

the following shud not display the select if sub category selection has been made.

echo "<form name='form1'>";
	if (isset($_REQUEST['sub_cat'])
	{
		echo "<select name='catergorylist' onChange='go(this)'>"; 
		echo "<option selected >Please Select:</option>"; 
		$more_cat = MYSQL_NUM_ROWS($sql_select);     

	while ($row = mysql_fetch_array($sql_select)) 
	{ 
		$cat_id_list = $row['cat_id']; 
		$category = $row['category']; 

		echo"<option value='index.php?cat_id=" . $cat_id . "&sub_cat=" .$cat_id_list ."'>" .$category ."</option>"; 
	} 

	echo"</select>";
}
echo "</form>";

hope this helps u.... i am for my part pretty confused already! 😕

iceman2g

What are all the "." for just curious as i've never used them before.

Is it being because there is two or more variables.

PallaviDalvi

they have just the same implication as the '.' in this peice of ur code!

$sql_select = mysql_query( "SELECT * FROM " . $prefix . "store_category where cat_id='$cat_id' order by $cat_order");

🙂

iceman2g

haha, I honestly don't know.

I woulda have used "store_category where cat_id='$cat_id' order by $cat_order" without the . $prefix . but that's how it was entered in the other files that query mysql.

PallaviDalvi

welcome to the world of copy-paste! '.' is the string concatenation operator in PHP! so in my code...i'm just concatenating strings so they can be echoed. Hope that makes my code clearer!
PS: a note for the future... even in the age of copy-paste...it doesnt hurt to understand the code ur copying before u expect it to work! 🙂

iceman2g

I'll definately remember that. Thanks again.