SELECT *, GEODIST(1.125364,104.045982,latitude,longitude,'in=deg') AS distance FROM indexmnkl WHERE latitude IS NOT NULL AND longitude IS NOT NULL HAVING distance < 50000 ORDER BY distance ASC LIMIT 100
Fatal error: Uncaught mysqli_sql_exception: table indexmnkl: parse error: geodist() arguments can not be string in /home/w/01mk/_____/f.php:212 Stack trace: #0 /home/w/01mk/_____/f.php(212): mysqli->query('\r\nSELECT *, GEO...') #1 /home/w/01mk/o/single.php(22): near_restaurant(1.125364, 104.045982, 100, 50000) #2 /home/w/01mk/index.php(9): require_once('/home/w/01mk/o/...') #3 {main} thrown in /home/w/01mk/_____/f.php on line 212