Calculating Distance

Soldato
Joined
4 Jul 2004
Posts
2,647
Location
aberdeen
Hello,
I have a list of locations and a list of users (in longitude / latitude). How can I make a query in mysql so it is like (in plain english here:)
where longitude is between x-100 and x+100 and where latitude is between y-100 and y+100
(if x was the users latitude position, y their long)

thanks
 
Back
Top Bottom