ART
ARCHITECTURE
& HISTORY
in the Public Realm
unable to execute query SELECT record_id, name_title, center, type, SUBSTRING_INDEX( `center`, ', ', 1 ) AS latitude, SUBSTRING_INDEX( `center`, ', ', -1 ) AS longitude, (((acos(sin((* pi()/180 )) * sin((SUBSTRING_INDEX( center, ', ', 1 ) * pi()/180 ))+cos(( * pi()/180)) * cos((SUBSTRING_INDEX( center, ', ', 1 ) * pi()/180)) * cos(((- SUBSTRING_INDEX( center, ', ', -1 )) * pi()/180)))) * 180/pi()) * 60 * 1.1515 * 1.609344 ) * 5280 AS distance FROM item WHERE center != '' AND record_id != '' AND live = '1' ORDER BY distance ASC LIMIT 7: 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((SUBSTRING_INDEX( center, ', ', 1 ) * pi()/180 ))+cos(( ' at line 8