title: Why is my code giving me an SQL error
body: <p>My following SQL code is showing up an error. The error message that appears in phpMyAdmin is </p>
  
  <blockquote>
    <p>#1064 - 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 'long = -6.52607, lat = 54.10046, reg = 'Rge info ere', info = 'general info here' at line 1</p>
  </blockquote>
  
  <p>The long and lat work ok when i insert them directly using phpmyadmin but now when performing an sql query. The two fields are set as float. Ive tired them both with and without using signle quotes.</p>
  
  <pre><code>INSERT INTO events SET 
    name = 'Home Event', 
    url = 'home-event', 
    eventDate = '2013-06-29', 
    address1 = '18 Daly Park', 
    address2 = 'Silverbridge', 
    city = 'Newry', 
    county = 'Down', 
    postcode = 'BT35 9PJ', 
    long = -6.52607, 
    lat = 54.10046, 
    reg = 'Rge info ere', 
    info = 'general info here', 
    contact = 'contact me', 
    image = ''
  </code></pre>