find nearby location using zipcode lookup within certain radius

[rashgang]

i am tryingn to find the near by location using zipcode and given radius. i am calculating using havesen forumula

Please see the below example.

 

I'm not getting exact results

 

for example i am searching for 50 miles 35004 zipcode it is showing same results. i have stored longitude and latitude of 35005 it is not listing in the results

 

zipcode latitude longitude

35005 33.592585 -86.959690

 

 

 

zipcode latitude longitude

35005 33.592585 -86.959690  

 

 

The following formula is right one or have to use other formula

 

j.lknjobs_latitude = stored table column of latitude

 

j.lknjobs_longitude = stored table column of longitude

 

 

 

ex:

(3959 * acos(cos(radians($latitude)) * cos( radians( j.lknjobs_latitude ) ) * cos( radians( j.lknjobs_longitude ) -
radians( $longitude ) ) + sin( radians( $latitude ) ) * sin( radians( j.lknjobs_latitude ) ) ) )
) AS distance ";

 

[mac_gyver]

the portion of the query you posted only calculates the distance. how are you using that value in the query to determine which rows are returned?

[fenway]

Also, it's rare that you need the exact distance -- pythagoras does a better faster job anyway.  You can't drive straight-line distance anyway.