I have a script to enter into a table based upon variables.
PHP Code:
$raf_insert = "INSERT INTO raf_keys (id,key,active)
VALUES('$accountinfo', '$rafnumber', '3')";
mysql_query($raf_insert) or trigger_error(mysql_error()." in ".$raf_insert);
This is the error I receive:
PHP Code:
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 'key,active) VALUES('5', '8903251', '3')' at line 1 in INSERT INTO raf_keys (id,key,active) VALUES('5', '8903251', '3')
The error lets me know that it is picking up the values of the account and the random number, but for some reason it has the error running at id I believe. Does anyone know what I could do to fix this?
Thanks