0){ $quer=mysql_query("SELECT DISTINCT subcategory,subcat_id FROM subcategory where cat_id=$cat order by subcategory"); }else{$quer=mysql_query("SELECT DISTINCT subcategory,subcat_id FROM subcategory order by subcategory"); } ////////// end of query for second subcategory drop down list box /////////////////////////// /////// for Third drop down list we will check if sub category is selected else we will display all the subcategory3///// $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 subcat2 FROM subcategory2 where subcat_id=$cat3 order by subcat2"); }else{$quer3=mysql_query("SELECT DISTINCT subcat2 FROM subcategory2 order by subcat2"); } ////////// end of query for third subcategory drop down list box /////////////////////////// ?>  

"; echo "Scopri i punti vendita Azzurra design più vicini a te

"; // echo "

"; echo ""; ////////// Starting of first drop downlist ///////// echo "Seleziona il Paese"; while($noticia2 = mysql_fetch_array($quer2)) { if($noticia2['cat_id']==@$cat){echo "$noticia2[category]"."
";} else{echo "$noticia2[category]";} } echo ""; ////////////////// This will end the first drop down list /////////// echo "
"; ////////// Starting of second drop downlist ///////// echo "
Seleziona la Regione"; while($noticia = mysql_fetch_array($quer)) { if($noticia['subcat_id']==@$cat3){echo "$noticia[subcategory]"."
";} else{echo "$noticia[subcategory]";} } echo ""; ////////////////// This will end the second drop down list /////////// echo "
"; ////////// Starting of third drop downlist ///////// echo "
Seleziona la Città"; while($noticia = mysql_fetch_array($quer3)) { echo "$noticia[subcat2]"; } echo ""; ////////////////// This will end the third drop down list /////////// //echo "
"; //echo "

"; ?> "; echo "
"; //$queryz="SELECT * FROM `subcategory3` WHERE `subcat2` LIKE '$subcat3' LIMIT 0 , 30"; $queryz="SELECT * FROM `subcategory3` WHERE `subcat2` LIKE '$subcat3'"; $result=mysql_query("$queryz"); while($row = mysql_fetch_array($result)) { echo "" . $row['Company'] . "
"; echo $row['Address'] . "
"; echo $row['Zip'] . " " . $row['City'] . " " . $row['Country'] . "
"; if ($row['Telephone'] == true ) { echo "Telefono " . $row['Telephone']. "
"; }; if ($row['Fax'] == true ) { echo "Fax " . $row['Fax']. "
"; }; if ($row['Email'] == true ) { echo "Email " . $row['Email']. "
"; }; if ($row['Web'] == true ) { echo "Web " . $row['Web']. "
"; }; if ($row['Social'] == true ) { echo "Social " . $row['Social']. "
"; }; echo "
"; } echo "

"; } ?>