"; if($country_result['countrydescription'] <> "") echo ""; $province_query = mysql_query("SELECT DISTINCT p.provinceID, p.provincename FROM tbldealer d LEFT JOIN tblprovince p ON d.provinceID = p.provinceID WHERE d.countryID = '".$country_result['countryID']."'"); while($province_result = mysql_fetch_array($province_query)) { if($province_result['provinceID']<>"") { echo ""; $provinceID = $province_result['provinceID']; } else $provinceID = 0; $class = "light1"; $dealer_query = mysql_query("SELECT * FROM tbldealer WHERE countryID = '".$country_result['countryID']."' AND provinceID = '".$provinceID."' AND dealerdelete = '0'"); while($dealer_result = mysql_fetch_array($dealer_query)) { echo ""; if($class=="light1") $class = "light5"; else $class = "light1"; } } echo ""; } ?>

".$country_result['countryname']."

".$country_result['countrydescription']."

".$province_result['provincename']."

".stripslashes($dealer_result['dealercity'])."

".stripslashes($dealer_result['dealername'])."

"; if(strpos($dealer_result['dealerwebsite'],'@')<>"") echo "".$dealer_result['dealerwebsite'].""; elseif(strpos($dealer_result['dealerwebsite'],'http://')<>"") echo "".$dealer_result['dealerwebsite'].""; else echo "".$dealer_result['dealerwebsite'].""; echo "

".$dealer_result['dealerphone']."