[RESOLVED] Error on duplicate key update

[lpa]

Hello,

Can anyone help me with this error?

Thank you.

mysql_query("INSERT INTO session VALUES('$user', '$ctime', '$ip', '$guest') ON duplicate KEY UPDATE time='$ctime' WHERE user='$user'") or die(mysql_error());

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 'WHERE user='48'' at line 1

[laserlight]

The WHERE clause should not be present. If the insertion would cause a unique constraint violation, then the existing row must be identifiable. Since it can already be identified, the WHERE clause for the UPDATE would then be pointless. Read MySQL's documentation on INSERT ... ON DUPLICATE KEY UPDATE Syntax.

[lpa]

Thank you laserlight!
It worked.