what's wrong with this mysql query?

[daverico]

UPDATE user SET user_id=$user_id , username=$username , password=$password , priv=$priv , first_name=$first_name , last_name=$last_name , email_address=$email_address WHERE user_id = 1

=========================

it gives the output

=========================

Unknown column '$user_id' in 'field list'

=========================

Anyone got an idea of what is happening or how to fix this?

[kidsleep]

try enclosing $user_id in single quotes ie '$user_id'