$queryCountries="SELECT * FROM tblCountries WHERE countryID=1"; $resultCountries=mysql_query($queryCountries); $numCountries=mysql_numrows($resultCountries); $queryCountries1="SELECT * FROM tblCountries WHERE countryID!=1 AND countryID!=14 AND countryID!=16 ORDER BY countryName ASC"; $resultCountries1=mysql_query($queryCountries1); $numCountries1=mysql_numrows($resultCountries1); $queryCountries2="SELECT * FROM tblCountries WHERE countryID=14 OR countryID=16 ORDER BY countryName ASC"; $resultCountries2=mysql_query($queryCountries2); $numCountries2=mysql_numrows($resultCountries2); $total = $numCountries + $numCountries1 + $numCountries2; $i=0; while ($i < $total) { if ($i < $numCountries){ $countryID=mysql_result($resultCountries,$i,"countryID"); $countryName=mysql_result($resultCountries,$i,"countryName"); } else { $temp = $numCountries + $numCountries1; if ($i < $temp){ $i1 = $i-$numCountries; $countryID=mysql_result($resultCountries1,$i1,"countryID"); $countryName=mysql_result($resultCountries1,$i1,"countryName"); } else { $i2 = $i-$numCountries-$numCountries1; $countryID=mysql_result($resultCountries2,$i2,"countryID"); $countryName=mysql_result($resultCountries2,$i2,"countryName"); } } $queryStates="SELECT * FROM tblStates WHERE countryID=$countryID ORDER BY stateName ASC"; $resultStates=mysql_query($queryStates); $numStates=mysql_numrows($resultStates); $countryDisplay = 1; $j=0; while ($j < $numStates) { $stateID=mysql_result($resultStates,$j,"stateID"); $stateName=mysql_result($resultStates,$j,"stateName"); $queryCities="SELECT * FROM tblCities WHERE stateID=$stateID ORDER BY cityName ASC"; $resultCities=mysql_query($queryCities); $numCities=mysql_numrows($resultCities); $stateDisplay = 1; $k=0; while ($k < $numCities) { $cityID=mysql_result($resultCities,$k,"cityID"); $cityName=mysql_result($resultCities,$k,"cityName"); $queryLoc="SELECT * FROM tblLocations WHERE cityID=$cityID ORDER BY locName ASC"; $resultLoc=mysql_query($queryLoc); $numLoc=mysql_numrows($resultLoc); $cityDisplay = 1; $l=0; while ($l < $numLoc) { $locID=mysql_result($resultLoc,$l,"locID"); $locName=mysql_result($resultLoc,$l,"locName"); $queryEC="SELECT * FROM tblEC WHERE locID=$locID AND ecTrades!=0"; $resultEC=mysql_query($queryEC); $numEC=mysql_numrows($resultEC); $locDisplay = 1; $m=0; while ($m < $numEC) { $ecID=mysql_result($resultEC,$m,"ecID"); $ecImage=mysql_result($resultEC,$m,"ecImage"); $ecRevImage=mysql_result($resultEC,$m,"ecRevImage"); $ecText=mysql_result($resultEC,$m,"ecText"); $ecRevText=mysql_result($resultEC,$m,"ecRevText"); $denomID=mysql_result($resultEC,$m,"denomID"); $statusID=mysql_result($resultEC,$m,"statusID"); $ecTrades=mysql_result($resultEC,$m,"ecTrades"); $ecTradeNotes=mysql_result($resultEC,$m,"ecTradeNotes"); if($countryDisplay == 1){ echo "