UBB.Developers Forums Community Development Programming PHP and Server-side Scripting can't update mysql field

OK, I've been trying to get this to work for over a week, but still no luck.

What I'm trying to do is this: I have an upload script that's a modified attachment uploader for a php forum (don't kill me! it's easier to integrate with the site). I'm trying to add an option so that I can "lock" the file. When the file is "locked", the forum loads a template displaying all information on the file except the actual download link. This works perfectly fine if I manually edit the mysql field through phpadmin, but I can't get the script to work right so that I can lock it from the forum.

my php code (more or less):

I've tried tons of different ways to do it (both html and code wise) but can't get it to work.

that's the code as I have it right now. Doesn't give me any errors, just doesn't set attachments[attach_status] to 1 (in the db) when I want it too.

link: http://filedb.4x4customs.net/thread.php?threadid=54&boardid=14&page=1#1

pic: http://www.4x4customs.net/staff/gts/editscreen.jpg

Couple of things....

Firstly.. Your Input checkbox doesn't line up with an variables. Supposed to be like that?

Secondly.. If you can output the SQL Statement
e.g.

echo ("UPDATE bb".$n."_attachments SET attach_status='0' WHERE attachmentid='$post[uploadid]'");
in the first one and
echo ("UPDATE bb".$n."_attachments SET attach_status='1' WHERE attachmendid='$post[uploadid]'");

in the second.
this will help you see if the SQL is doing what you're wanting it to do.