SELECT * FROM postcodelatlng WHERE ( 3958 * 3.1415926 * sqrt( (latitude - '.$lat.') * (latitude - '.$lat.') + cos(latitude/57.29578) * cos('.$lat.'/57.29578) * (longitude-'.$lon.') * (longitude-'.$lon.') ) / 180 ) <= '.$radius.';'
Quote:this query is working perfectly fine .but i dont get the formula .how is it working .
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)