Syntax

[Kudose]

mysql_query("INSERT INTO rable (username, name, eta, descrip, chems, procedure, affect, timestamp, ip, id)
VALUES ('$username', '$name', '$eta', '$descrip', '$chems', '$procedure', '$affect', '$timestamp', '$ip', '$id')") or die(mysql_error());

gives me:

You have an error in your SQL syntax near 'procedure, affect, timestamp, ip, id) VALUES ('Kudose', 'Test', 'test time', 't' at line 1

Anyideas?

THANKS!

[sijis]

it looks good to me.
just make sure the spelling is correct and
that the passed values don't have quotes.

mysql_query("INSERT INTO rable (username, name, eta, descrip, chems, procedure, affect, timestamp, ip, id) 
VALUES ('$username', '$name', '$eta', '$descrip', '$chems', '$procedure', '$affect', '$timestamp', '$ip', '$id')") or die(mysql_error()); 

[ahundiak]

Procedure is a reserved work in mysql.
http://www.mysql.com/doc/en/Reserved_words.html

[trooper]

Insert into rable????????

HTH

GM

Originally posted by Kudose
mysql_query("INSERT INTO rable (username, name, eta, descrip, chems, procedure, affect, timestamp, ip, id)
VALUES ('$username', '$name', '$eta', '$descrip', '$chems', '$procedure', '$affect', '$timestamp', '$ip', '$id')") or die(mysql_error());

gives me:

You have an error in your SQL syntax near 'procedure, affect, timestamp, ip, id) VALUES ('Kudose', 'Test', 'test time', 't' at line 1

Anyideas?

THANKS!

[RedDragon]

many fieldnames such as
exec, from and where, update are not valid in mysql as they are used in parsing queries... to make it valid change the name or do it the following:

mysql_query("INSERT INTO rable (username, name, eta, descrip, chems, `procedure`, affect, timestamp, ip, id) 
VALUES ('$username', '$name', '$eta', '$descrip', '$chems', '$procedure', '$affect', '$timestamp', '$ip', '$id')") or die(mysql_error()); 

the shows mysql that the word is a fieldname and not a command what to do with the query

[Kudose]

Yes the table name is rable

And I found that the issue is the field name being procedure and the variable name being procedure, because procedue is a dedicated mysql command, and cannot be used. Once I changed the name from procedure to how it worked fine.

Thank everyone thoguh.