Friday, 25 November 2016

Find nearest based on GPS


SELECT ( 3959 * acos( cos( radians(28.6219459) ) * cos( radians( Latitude ) ) * 
cos( radians( Longitude ) - radians(77.384108) ) + sin( radians(28.6219459) ) * 
sin( radians( Latitude ) ) ) ) AS distance,DealerName,DealerID 
FROM jcb.tbl_dealer_list HAVING distance < 10 ORDER BY distance LIMIT 0 , 20;

No comments:

Post a Comment