Skip to content

Instantly share code, notes, and snippets.

@billy-the-kid

billy-the-kid/results

Created April 20, 2012 02:31
Show Gist options
  • Save billy-the-kid/2425419 to your computer and use it in GitHub Desktop.
Save billy-the-kid/2425419 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
results
$lat = $_POST['f_latitude'];
$longi = $_POST['f_longitude'];
$zip = $_POST['f_enterAZip'];
$finalLat = floatval($lat);
$finalLong =floatval($longi);
$query = "SELECT stores_storeName, SQRT(POW($finalLat-stores_latitude, 2)+POW($finalLong-stores_longitude, 2)) AS closest FROM Stores ORDER BY closest ASC;";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment