location bounty - get proximity search working

The query should be something like this

>>>>>
$query = "SELECT i.itemid, i.title, lng.data_txt as lng, lat.data_txt as lat, ";
// Haversine formula
$query .= "( %s * acos( cos( radians(%s) ) * cos( radians( lat.data_txt) ) * cos( radians( lng.data_txt) - radians(%s) ) + sin( radians(%s) ) * sin( radians( lat.data_txt) ) ) ) as distance ";
$query .= "FROM db_item as i, db_fields_data as lat, db_fields_data as lng ";
$query .= "WHERE lng.itemid=i.itemid and lat.itemid=i.itemid and ";
// Change these numbers to your fieldid's
// Fieldid 13 is the longitude field
// Fieldid 12 is the latitude field
$query .= "lng.fieldid=16 and lat.fieldid=15 ";

if ($radius!="")
{
// if theres a radius, then limit the results
$query .= "HAVING distance <= " . $radius . " ";
}
$query .= "ORDER BY distance ";
$query .= "LIMIT 20 ";

>>>>>>