SELECT *, GEODIST(-5.16878271, 119.450043, latitude, longitude, 'in=deg') AS distance
FROM indexmnkl
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:205
Stack trace:
#0 /home/w/01mk/_____/f.php(205): mysqli->query('\r\n SELECT *,...')
#1 /home/w/01mk/o/single.php(22): near_restaurant(-5.16878271, 119.450043, 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 205