| tehste |
03-04-2004 07:14 AM |
MYSQL error 1064
I tried looking through all the threads but I could not find an answer.
I'm making a hack and getting a 1064 error when i try to insert a new row through the admin cp.
I would appreciate help with this.
error
Quote:
Database error in vBulletin 3.0.0 Release Candidate 4:
Invalid SQL:
INSERT INTO hack_settings
(ON,ALL,PST,RFRL,NSUP,INTR,CCST,CREV,CLIC,SELL,LOG ) VALUES('0','0','','','','','','','','','0')
mysql error: 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 'ON,ALL,PST,RFRL,NSUP,INTR,CCST,CREV,CLIC,SELL,LOG ) VALUES('0','
mysql error number: 1064
|
The table and colomns exist and im really puzzeled about this.
PHP
PHP Code:
$DB_site->query("
INSERT INTO " . TABLE_PREFIX . "hack_settings
(ON,ALL,PST,RFRL,NSUP,INTR,CCST,CREV,CLIC,SELL,LOG) VALUES('$settings[ON]','$settings[ALL]','$settings[PST]','$settings[RFRL]','$settings[NSUP]','$settings[INTR]','$settings[CCST]','$settings[CREV]','$settings[CLIC]','$settings[SELL]','$settings[LOG]')
");
Thanks for any help :) |
More Information