PLEASE VERIFY MySQL SYNTAX

[kelvin24]

What is wrong with this syntax?

Code: Select all

$log="UPDATE log SET logouttime='$time' WHERE username='$_SESSION['username']'";

[Nullsig]

Really you should escape out of the string when dealing with PHP variables. In this case the single quotes in your session variable are ending the quote surrounding it prematurely.

Code: Select all

$log="UPDATE log SET logouttime='" . $time . "' WHERE username='" . $_SESSION['username'] . "'";