ART
ARCHITECTURE
& HISTORY
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 != '00240' 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