forum lock help..

Smackie

Well im adding a script where it will lock topics in my forum (only for admins) i already got the lock to work its just making it so when making a topic or editing one to make it lock is where im having a problem..

i know this is easy lol but i must be over looking something.. before i post the where im having the problem at.. just one question in database i have lock as enum ('0', '1') now do i have to have a different way of changing that?? now here is the script

$sql="INSERT INTO forum_question(forumid, topic, detail, userid, lastpost, lock, datetime)VALUES('$forumid', '$topic', '$detail', '$userid', '$lastpost', '$lock', now())";
$result=mysql_query($sql);

now when i try adding a topic with this i get error. now if i take out lock, and '$lock', it adds the post :S

Please help me

Smackie

bradgrafelman

What's the error? What is $lock set to?

Smackie

i get this when i put or die(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 'lock, datetime)VALUES('1', 'test', 'test', '14', '1', now())' at line 1

bradgrafelman

Try surrounding the field names in backticks, like so:

INSERT INTO forum_question (`forumid`, `topic`, `detail`, `userid`, ...

The problem is that "lock" is a reserved word in MySQL. Using backticks explicitly tells MySQL that you're referencing columns (or tables or databases) and not a MySQL syntax/command/etc.

Smackie

yeah i found it that out lol earlier today 🙂

bradgrafelman

So, does that mean your issue is resolved? If so, don't forget to mark this thread resolved.