TalkPHP - View Single Post

Bravo81 · 06-13-2008, 05:16 PM

Ok, now I get:

Query failed: 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 ''username', 'password', 'activated', 'online', 'email', 'status', 'tut', 'active' at line 1

Im confused.

The code is:

Code:

mysql_query("INSERT INTO `users` ('username', 'password', 'activated', 'online', 'email', 'status', 'tut', 'activecode')
VALUES ('$reg_username', '$randompassword', '0', '0', '$email', 'Alive', '0', '$code')");
if (mysql_affected_rows() != 1) die ('Query failed: '.mysql_error());

I have removed all other columns from the table.

The code is inserting into the only columns in the table in order.

Thanks for the responses,

Dean.

06-13-2008, 05:16 PM	#6 (permalink)
Bravo81 The Visitor Join Date: Jun 2008 Posts: 3 Thanks: 2	Ok, now I get: Query failed: 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 ''username', 'password', 'activated', 'online', 'email', 'status', 'tut', 'active' at line 1 Im confused. The code is: Code: mysql_query("INSERT INTO `users` ('username', 'password', 'activated', 'online', 'email', 'status', 'tut', 'activecode') VALUES ('$reg_username', '$randompassword', '0', '0', '$email', 'Alive', '0', '$code')"); if (mysql_affected_rows() != 1) die ('Query failed: '.mysql_error()); I have removed all other columns from the table. The code is inserting into the only columns in the table in order. Thanks for the responses, Dean.