By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,188 Members | 832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,188 IT Pros & Developers. It's quick & easy.

php syntax error

P: 1
// This is my echo sql
INSERT INTO order(TRXDATE,TRXTIME,TOTAMOUNT,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,TOTAMOUNT,CUST_ID) VALUES('2012-02-21','05:04:16','326','1' at line 1
Feb 20 '12 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 5K+
P: 8,639
order is a reserved keyword in MySQL. it would be best to rename that table.
Feb 20 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.