mysql syntax help

I've been trying to figure this out for a while, but haven't got a clue what's wrong with it.


$sql = "UPDATE se_author SET fname=$fname, lname=$lname, address=$adress, phone=$phone, email=$email WHERE auth_id=$auth_id";

every time I send that query to the mysql server I get this error. If you have any idea whats wrong I would love to know.

You have an error in your SQL syntax near ' phone=*****, email=*****, WHERE auth_id=3' at line 1


*** added for privacy, but the values that where there are what they should be.

e-mail me at
atari900@dreamformula.com

thanks

You forgot some quotes


$sql = "UPDATE se_author SET fname='$fname', lname='$lname', address='$adress', phone='$phone', email='$email' WHERE auth_id='$auth_id'";

thanks, adding the quotes worked.