PLease inform to that who is working in this site.
Browse from IP Address :   Browse Date:22 09, 2018 09:42:33 AM
ERROR IN MYSQL QUERY

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 ' , restaurant_lat, restaurant_long),1) as distance, cty.cityname, rest.restaur' at line 1

SERVER VARIABLES:

Error in Selection Query
SELECT rest.restaurant_id, rest.restaurant_name, rest.restaurant_seourl, rest.restaurant_lat,rest.restaurant_long,rest.restaurant_phone, rest.restaurant_logo, rest.restaurant_website, rest.restaurant_zip, rest.restaurant_state, rest.restaurant_timezone, rest.restaurant_fax, rest.restaurant_streetaddress, rest.restaurant_contact_name, rest.restaurant_contact_phone, rest.restaurant_contact_email, rest.restaurant_description, rest.restaurant_estimated_time, rest.restaurant_delivery, rest.restaurant_pickup, rest.restaurant_delivery_charge, rest.restaurant_minorder_price, rest.restaurant_serving_cuisines, rest.restaurant_feature_status, restaurant_booktable, round(GetDistance2(, , restaurant_lat, restaurant_long),1) as distance, cty.cityname, rest.restaurant_zip AS zipcode, state.statename FROM rt_restaurant AS rest LEFT JOIN rt_city AS cty ON rest.restaurant_city = cty.city_id LEFT JOIN rt_state AS state ON rest.restaurant_state = state.statecode WHERE rest.restaurant_status = '1' AND rest.delete_status = 'NO' AND (rest.restaurant_delivery = 'Yes' OR rest.restaurant_pickup = 'Yes') AND lower(cty.cityname) = 'goose creek' AND cui.cuisine_id = '49' GROUP BY rest.restaurant_id
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 ' , restaurant_lat, restaurant_long),1) as distance, cty.cityname, rest.restaur' at line 1