SELECT *, GEODIST(1.11166966,103.964828,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
<br />
<b>Fatal error</b>:  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-&gt;query('\r\nSELECT *, GEO...')
#1 /home/w/01mk/o/single.php(22): near_restaurant(1.11166966, 103.964828, 100, 50000)
#2 /home/w/01mk/index.php(9): require_once('/home/w/01mk/o/...')
#3 {main}
  thrown in <b>/home/w/01mk/_____/f.php</b> on line <b>212</b><br />