[RESOLVED] MySQL Update query gives syntax error

kanuj

I'm using this query for an update form:

$sqlUpd = "UPDATE employee SET fname = '$fname', lname = '$lname', title = '$title', email = '$email', id = '$id', pass = '$pass', all='$all', prepare_user_quotes = '$prepare_user_quotes', manage_jobs='$manage_jobs', manage_users='$manage_users', add_employee='$add_employee', add_process='$add_process', add_news_story='$add_news_story', add_dyk_tip='$add_dyk_tip', create_mail_list='$create_mail_list' WHERE unique_id='$val'" OR die(mysql_error());

but always seem to get a syntax error. I've tried all the available methods, but still syntax error pops up. This is the error I'm getting:

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 'all='1', prepare_user_quotes = '1', manage_jobs='0', manage_users='0', add_emplo' at line 1

Any help would be thankful.

bpat1434

Fisrt thing to try:
Splitting the SQL up onto different lines:

$sqlUpd = "UPDATE employee 
SET fname = '$fname',  

lname = '$lname', 
title = '$title', 
email = '$email', 
id = '$id', 
pass = '$pass', 
all='$all',
prepare_user_quotes = '$prepare_user_quotes',
manage_jobs='$manage_jobs', 
manage_users='$manage_users', 
add_employee='$add_employee', 
add_process='$add_process', 
add_news_story='$add_news_story', 
add_dyk_tip='$add_dyk_tip', 
create_mail_list='$create_mail_list'
WHERE unique_id='$val'";
$result = mysql_query($sqUpd) OR die(mysql_error());

The other thing I noticed (which is fixed in the above code, is that you didn't execute it anywhere....

And, it may have something to do with the quotes, I'm not sure.... Try this and see if we can narrow it down....

Drakla

All is a mysql reserved word - you'll have to put it between backticks like so:

all='$all'

kanuj

@: I did have the "mysql_query" function under the query itself, but I did'nt think posting it would've made a difference, considering I was getting a syntax error.

@: That did the trick! Thanks for this, it was giving me problems for soooo long....