[php] Edit single column in database returns false

[mikk809h]

Hello Pro's!

 

 

Im making a webpage, where i post a license key to it, and then the webpage has to edit the column "unlock" in the database "register_advlock" but. when debugging its returning false

 
$res = mysql_query("UPDATE register_advlock SET unlock='false' WHERE license_key='$key' AND unlock='true'", $con); -- somehow this returns false (connection to database is succesfully done)
    if ($res) {
     echo 'true';
    } else {
     echo 'false';
    }

but when doing or die(mysql_error()) after the mysql query it returns:

"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 'unlock='false' WHERE license_key='c83df0043dc323ae1ac1c62e24ab86871cc4cb36568416' at line 1"

 

 

Thanks in Advance

Edited May 14, 2013 by mikk809h

[requinix]

"unlock" is a reserved word.

[Kingy]

Putting ` characters around unlock should get it to work: `unlock`.  Either that or change the column name to not use a reserved word.

[mikk809h]

Thanks!!! now i found the problem.. as you said "unlock" was a reserver word, but if i added 'unlock' (the ' ´s) then it still doesnt work.. but now i've changed unlock to "locked" Thanks alot!