GPS坐标Mysql查询[关闭]

Question

Suppose i have $longitude=2; $latitude =3; i want to get information from database

Select * 
from info 
where longitude is between $longitude + 2 AND $longitude-2  
AND latitude is between $latitude + 2 AND $latitude -2

how can i write this query to get information of specific area

Answer 1

$longitude = 2;
$latitude = 3;

$longitude_min = $longitude - 2;
$longitude_max = $longitude + 2;
$latitude_min = $latitude - 2;
$latitude_max = $latitude +2;

$sql = "SELECT * FROM `info`
WHERE `longitude`>$longitude_min
AND `longitude`<$longitude_max
AND `latitude`>$latitude_min
AND `latitude`<$latitude_max";

$result = mysql_query($sql);