Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $latitude = 0; // latitude recherchée
- $longitude = 0; // longitude recherchée
- $query = 'SELECT *, SQRT(POW(ABS(ma_table.latitude-'.$latitude.')*40075.017/360,2)+POW(ABS(ma_table.longitude-'.$longitude.')*40007.864/360,2)) AS distance FROM ma_table ORDER BY distance ASC';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement