0

Hello, this error has been torturing me for an hour...
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 ''lock'='0' where pmID='206'' at line 1
This is the code:

else {                      
    print "Žinutė išsaugota.";
    $ui1="update km_pms set lock='0' where pmID='$x'";
    mysql_query($ui1) or die(mysql_error());            
  }

Can someone please tell me what I'm doing wrong?

Edited by preston326: n/a

1
Contributor
1
Reply
2
Views
6 Years
Discussion Span
Last Post by preston326
0

Ok so it seems that mySQL interpreted table column lock as a command, because when I changed it into lockas everything seems to work fine. Problem solved

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.