$quer2=mysql_query(“SELECT DISTINCT Prod_Type,PT_ID FROM Product_ID WHERE ((PT_ID = 0) OR (PT_ID = 1) OR (PT_ID >= 2 AND PT_ID <= 4) OR (PT_ID >= 7 AND PT_ID <= 8) OR (PT_ID >= 14 AND PT_ID <=16) OR (PT_ID >=31 AND PT_ID <= 37)) order by PT_ID”); $cat=$_GET['cat']; if(isset($cat) and strlen($cat) > 0) { $quer=mysql_query(“SELECT DISTINCT Manufacturer_ID.Manufacturer, Manufacturer_ID.Man_ID FROM Manufacturer_ID, Model_Numbers where ((Manufacturer_ID.Man_ID = Model_Numbers.Man_ID) AND (Model_Numbers.PT_ID = $cat)) order by Manufacturer”); }else{$quer=mysql_query(“SELECT DISTINCT Manufacturer,Manufacturer_ID FROM Manufacturer_ID order by Manufacturer”); } $cat3=$_GET['cat3']; // This line is added to take care if your global variable is off if(isset($cat3) and strlen($cat3) > 0) { $quer3=mysql_query(“SELECT DISTINCT Model_Num, Model_Num FROM Model_Numbers where ((Model_Numbers.Man_ID=$cat3) AND (Model_Numbers.PT_ID = $cat)) order by Model_Num”); }else{$quer3=mysql_query(“SELECT DISTINCT subcat2 FROM subcategory2 order by subcat2″); } echo “Select one”; while($noticia2 = mysql_fetch_array($quer2)) { if($noticia2['PT_ID']==@$cat){echo “$noticia2[Prod_Type]”.”
”;} else{echo “$noticia2[Prod_Type]”;} } echo “”; echo “Select one”; while($noticia = mysql_fetch_array($quer)) { if($noticia['Man_ID']==@$cat3){echo “$noticia[Manufacturer]”.”
”;} else{echo “$noticia[Manufacturer]”;} } echo “”; echo “Select one”; while($noticia = mysql_fetch_array($quer3)) { echo “$noticia[Model_Num]”; } echo “”; ?>