Having problems with my query

[Anon]

Having problems with updating the database with the following query:

DBQuery ("UPDATE Sessions SET login_id = '$user' AND login_expires = NOW() + INTERVAL 30 MINUTE WHERE session_no = '".addslashes($SESSION['session_no'])."'");

Only the login expiry field in the is being updated in the database, if I remove the login_expires from the query the database gets updated with the user's login id.

Why isn't the login_id being updated, am I missing somthing?

[Anon]

Instead of AND, use a comma:

UPDATE tbl SET field = 'value', field2 = 'value2'

Diego