php syntax error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • marlon ansale
    New Member
    • Feb 2012
    • 1

    php syntax error

    // This is my echo sql
    INSERT INTO order(TRXDATE,T RXTIME,TOTAMOUN T,CUST_ID) VALUES('2012-02-21','05:04:16', '326','1')

    //this is my error help please
    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 'order(TRXDATE, TRXTIME,TOTAMOU NT,CUST_ID) VALUES('2012-02-21','05:04:16', '326','1' at line 1
  • Dormilich
    Recognized Expert Expert
    • Aug 2008
    • 8694

    #2
    order is a reserved keyword in MySQL. it would be best to rename that table.

    Comment

    Working...