Miscellany

$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), "<br>\n";

  while($row = mysql_fetch_array($storeRS)){
        echo "<tr align='center'> <td align='left'>", $row[0], "<br>",$row[1], "<br>",$row[2], ", ", $row[3],"<br>","<a href='$row[6]'>Web Site</a>", "<br>",$row[7], "<br><br></td></tr>";


  }