SELECT *, GEODIST(-1.23463857,116.872551,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.23463857, 116.872551, 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