Error: [256] Database 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 '* PI() / 180) * SIN(`lat` * PI() / 180) + COS( * PI() / 180) * COS(`lat` * PI() ' at line 1
Query: SELECT ((ACOS(SIN( * PI() / 180) * SIN(`lat` * PI() / 180) + COS( * PI() / 180) * COS(`lat` * PI() / 180) * COS(( - `lng`) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance, location_details.city, location_details.country, location_details.street, location_details.state, txtcontent.title, menu.title as menutitle FROM `location_details` INNER JOIN txtcontent ON txtcontent.id = location_details.parent INNER JOIN menu ON menu.id=txtcontent.parent WHERE location_details.lat!='0' ORDER BY distance ASC LIMIT 1, 5
Line [20]: /var/www/vhosts/battlefieldlive.com/httpdocs/includes/dblib.inc
Ending Script |
