http://stackoverflow.com/q
Good luck
SELECT * , ((
ACOS( SIN( ".$lat." * PI( ) /180 ) * SIN( lat_centroid * PI( ) /180 ) + COS( ".$lat." * PI( ) /180 ) * COS( lat_centroid * PI( ) /180 ) * COS( (
".$long." - long_centroid) * PI( ) /180 ) ) *180 / PI( )) *60 * 1.1515) AS `distance` FROM ".$this->table." HAVING distance <=100 ORDER BY distance LIMIT 0 , 10
Title | # Comments | Views | Activity |
---|---|---|---|
spacing | 5 | 25 | |
Get Javascript URL parameters | 7 | 27 | |
How do I edit this Drupal page? | 9 | 26 | |
PHP MySQL MySQLi Update Insert, and mapping XML data to MySQL Columns | 13 | 15 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
10 Experts available now in Live!