NVB Database Error


mySQL query error: SELECT *,3956 * 2 * ASIN(SQRT( POWER(SIN((20.4303288 - abs( project.latitude)) * pi()/180 / 2),2) + COS(20.4303288 * pi()/180 ) * COS(abs(project.latitude) * pi()/180) * POWER(SIN((106.16162359999998 – project.longitude) * pi()/180 / 2), 2) )) as distance FROM project HAVING distance < 5 ORDER BY thu_tu DESC, name ASC mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '– project.longitude) * pi()/180 / 2), 2) )) as distance FROM project HAVING d' at line 1 mySQL error code: Date: Tuesday 18th 2018f September 2018 04:12:19 PM