title: MySQL Error #1064 on this INSERT?
body: <p>Not sure what's wrong, just running this in PHP MyAdmin right now. Does anything pop out to you? Thanks.</p>
  
  <pre><code>INSERT INTO order (CustomerID, BillAddr, ShipAddr, Date, Total)   
  VALUES ('test', 'test', 'test', '2012-07-02', 22)
  </code></pre>
  
  <p>Error:</p>
  
  <blockquote>
    <p>MySQL said: #1064</p>
  </blockquote>
  
  <p>Structure of <code>order</code> table:  </p>
  
  <pre><code>FIELD                TYPE  
  OrderID         int(11) auto increment  
  CustomerID      varchar(50)  
  BillAddr        varchar(200)  
  ShipAddr        varchar(200)  
  Date            date  
  Total           double  
  </code></pre>
  
  <p>(I leave the OrderID out of the INSERT as it is an auto increment)   </p>
  
  <p><strong>EDIT</strong><br>
  Same error with this syntax:  </p>
  
  <pre><code>SQL query:
  
  INSERT INTO 'order'( CustomerID, BillAddr, ShipAddr, 'Date', Total )
  VALUES (
  'test', 'test', 'test', '2012-07-02', 22
  )
  MySQL said: Documentation
  #1064 - 
  </code></pre>