Codezwiz >> Forums >> General PHP Nuke Help >> Sql Query Error

$db->sql_query("UPDATE ".$prefix."_users SET user_new_privmsg = 1 WHERE user_id=" . $userdata['user_id'] . " LIMIT 1", $dbi);

Replace it with

   $q = "UPDATE " . $prefix . "_users
         SET user_new_privmsg = '1'
         WHERE user_id = ". $userdata['user_id'] ."
         LIMIT 1";
   $r = $db -> sql_query($q);

Parse error: parse error, expecting `','' or `';''

what part of the forums did you get that from

I am editing the pop up pm code in the CZ User login Block. I change the code to pop up an OK\Cancel Dialog box instead of the new windows. If the user selects cancel I would like to update user_new_privmsg field in the user table so the dialog box will stop after the user cancels it.

Basically if the user selects Cancel instead of OK, the user table gets updated so the pop up no longer will happen on next load.

In the code I gave it should say user_new_privmsg = '0', but that is not the error.

I just thought of something, Can you update the sql database from inside a javascript function? Because thats what I was doing. I think that is the error.

The line it says the parse error is on, paste the lines above & under it.

if ($dopmpopup == 1){
getusrinfo($user);
if ($userinfo['user_popup_pm'] && $userinfo['user_new_privmsg']) {
echo "<s cript language=\"Javas cript\" type=\"text/javas cript\">

</s cript>";
}

} else {
$content .= "";
}

You could set it so it will only pop up once if you cant get that to work:

getusrinfo($user);
if ($userinfo['user_popup_pm'] && $userinfo['user_new_privmsg']) {
echo "<script language=\"Javascript\" type=\"text/javascript\">

</script>";
$q = "UPDATE " . $prefix . "_users
SET user_new_privmsg = '1'
WHERE user_id = ". $userdata['user_id'] ."
LIMIT 1";
$r = $db -> sql_query($q);
}

Thanks I'll try that.