$sqlStore = "SELECT * FROM stores ORDER BY SQRT(POW((69.1*((SELECT ABS(latitude) FROM zipcodes WHERE zipcode='$zip')-ABS(latitude))),2)+POW((53*((SELECT ABS(longitude) FROM zipcodes WHERE zipcode='$zip')-ABS(longitude))),2)) LIMIT 10"; $storeRS = mysql_query($sqlStore); //echo mysql_num_rows($storeRS), "
\n"; while($row = mysql_fetch_array($storeRS)){ echo " ", $row[0], "
",$row[1], "
",$row[2], ", ", $row[3],"
","Web Site", "
",$row[7], "

"; }