UPDATE gives "Parse error"

[Anon]

Hi!

I'm having problem with my mysql database. When I want to update some fields, I get parse error. Here's the code snippet:

mysql_query("UPDATE personer SET inloggad=1, session_id=$sessionID WHERE id=$userid");

inloggad is either 1 or 0, depending on whether the user is logged in or not.

$sessionID is the current session id.

Maybe someone has a solution? Or perhaps a more efficient way of doing the same procedure?

Thanx in advance,

Erik

[matto]

are you sure your variables always contain values?

be sure such a thing won't happen:

UPDATE personer SET inloggad=1, session_id= WHERE id=7689789

dump out the query string and check it ...

[Anon]

May be such type of error always doesn't mean that the query is wrong. Look at the line before the query, if you vorgot some special characters like ; '...

[Anon]

Thanx for the help, although it hasn't solved my problems. I've narrowed the problem down to that the variables don't contain anything. At least the $userid one don't. $userid is supposed to be a global variable, but I must've gotten it wrong somehow... This is the code:

$userid=@mysql_result($result,$rows,"id");
session_register('userid');
$senastinne=@mysql_result($result,$rows,"tidstampel");
session_register('senastinne');

mysql_query("UPDATE personer SET inloggad=1,session_id=\"".session_id()."\" WHERE id=$userid");

Any ideas?

Thanx in advance,

Erik