Help with php query

[paschim]

function ltupdate($db,$user)
{
$now=time();
$upd_sql = "UPDATE $userRegTable SET accountLastActivity='$now' WHERE userName='$user'";
$sqlupd = $db->query($upd_sql);
return true;
}

I am getting a error saying I have wrong syntax in the mysql query!, any ideas?

[anon_login_001]

Is there any way you can show the actual error, or better - the actual query being sent?

[Maq]

$upd_sql = "UPDATE $userRegTable SET accountLastActivity='$now' WHERE userName='$user'";

 

Should be:

 

$upd_sql = "UPDATE '$userRegTable' SET accountLastActivity='$now' WHERE userName='$user'";

[paschim]

I tried that but i keep getting that weird error,

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 ''' SET accountLastActivity='1221848460' WHERE userName='guest'' at line 1

[Maq]

Try this, not sure if it will help...

 

$upd_sql = "UPDATE '" . $userRegTable . "' SET accountLastActivity = '" . $now . "' WHERE userName = . '" . $user . "'";

[paschim]

weirdly that worked, but can you tell me why i was getting that weird output in the previous case?

[fenway]

Don't quote table identifiers.