[SOLVED] Wrong Syntax???

[savagenoob]

I dont know what the heck is going on. This is a simply query and it is saying "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 'InOut = Out' at line 1"... cannot figure out why it is saying this. Here is the code snippet...

$employee = $_SESSION['SESS_MEMBER_ID'];
$inout = $_POST['punch'];
$query = "INSERT INTO timeclock SET Employee='$employee', InOut='$inout'";
$result = mysql_query($query);

[rhodesa]

you are mixing INSERT and UPDATE syntax...i assume you want INSERT:

INSERT INTO timeclock (Employee,InOut) VALUES ('$employee','$inout')

[savagenoob]

Yeah, but this doesnt work either... "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 'InOut) VALUES ('2','Out')' at line 1". Its like mysql is bugging out or something. Here is the query "INSERT INTO timeclock (Employee,InOut) VALUES ('2','Out')".

[rhodesa]

just checked...INOUT is a reserved word in MySQL...i would recommend changing the column name...but if you can't, you can use backticks:

INSERT INTO timeclock (Employee,`InOut`) VALUES ('$employee','$inout')

[savagenoob]

oh crap... no wonder... thanks

[revraz]

SET is valid with INSERTS, so you can change it back if you want with the new fieldname.

[rhodesa]

SET is valid with INSERTS, so you can change it back if you want with the new fieldname.

 

and i continue to learn new things

[savagenoob]

thanks guys, it works.