Within X miles of zipcode logic?

[cooldude832]

I have a table full of only USA addresses and I want to have a thing that says within X miles of Zipcode 12345

Lets say its 10 miles how do I derive the

Where Zip >= "12345-X" and ZIP <= "12345+x"

 

 

[Ken2k7]

I have a table full of only USA addresses and I want to have a thing that says within X miles of Zipcode 12345

Lets say its 10 miles how do I derive the

Where Zip >= "12345-X" and ZIP <= "12345+x"

Wait, that's not how distances work, or is it? ???

[revraz]

Long/Lat would be the best way, Zip would be unreliable

[cooldude832]

Zipcode is very reliable and the zipcodes are assigned via location ebay does it, I just don't know how the United States distributes zipcodes so I thought I asked someone.

 

and who in the world seriously knows their longitude/latitude position???

[cooldude832]

I'm assuming I'm going to have to find a table of US Zipcodes that has their lognitude/lattitude position and then from that zip code convert the miles into a range, find all zipcodes in that range and then use it in my query.

[Hypnos]

There are free web APIs out there to convert addresses to Lat/Long. It's called geocoding.

 

I don't know that any of them will just take a zip code. But there might be some out there.

[Ken2k7]

How would zip codes tell distances anyways? There are only a handful of zip codes that exist anyways. Not every number can be a zip code.

 

Say my zip code is 32154 and I want 1 mile away from both sides. So you're saying 32155 and 32153 are zip codes too?

[cooldude832]

How would zip codes tell distances anyways? There are only a handful of zip codes that exist anyways. Not every number can be a zip code.

 

There isn't a "handful" of zip codes, its a number defining a region in the Untied states by the Us Postal service.

Everyone knows the zipcode of their location.

 

I think this is beyond your scope, I found a db dump on it, but I think there is a simplier way

[revraz]

I do

 

 

 

and who in the world seriously knows their longitude/latitude position???

[cooldude832]

well your unusualy what i came up with works

<?php
if(!empty($_GET)){
connectSQL();
$miles = intval($_GET['miles']);
$zip = intval($_GET['zip']);
if(strlen($zip) != 5){
	echo "Invalid Zip";
}
if(!empty($miles) && strlen($zip) == 5){
	connectSQL();
	$distance = $miles*(1/69);
	$q = "Select lng, lat from `zips` Where zip = '".$zip."'";
	$r = mysql_query($q) or die(Mysql_error()."<br /><br />".$q);
	if(mysql_num_rows($r) >0){
		$row = mysql_fetch_assoc($r);
		$min['lat'] = round($row['lat']-$distance,5);
		$min['lng'] = round($row['lng']-$distance,5);
		$max['lat'] = round($row['lat']+$distance,5);
		$max['lng'] = round($row['lng']+$distance,5);
		$where = "lat >= '".$min['lat']."' and lat <= '".$max['lat']."' and lng >='".$min['lng']."' and lng <='".$max['lng']."'";

		$q = "Select zip from `zips` Where ".$where;
		$r = mysql_query($q) or die(mysql_error()."<br /><br />".$q);
		if(mysql_num_rows($r) >0){
			while($row = mysql_fetch_assoc($r)){
				$zips[] = $row['zip'];
			}
		}
		else{
			echo "No Records found.<br />".$q;
		}
	}
	else{
		echo "Invalid Zip.";
	}
}
else{
	echo "Not valid search parameters.";
}
}
?>

[revraz]

Hey look at that, Lat and Long...

[cooldude832]

Hey look at that, Lat and Long...

 

yeah but thats like asking a person what their weight is in Newtons, they don't know, but they probably know their weight is in pounds so you convert it.  I thought there was a very generic zip -> location (lat,long) system based on the numbers, but I guess not.