[Resolved] Update Syntax - Can I use "IF"?

[Spire2000]

I've been struggling with this one for a couple days now. Basically, I have a small form that updates two fields in a database. I have a third field that contains a password. What I would like to have is an update statement for the form process that updates the two fields, as long as a third field in the form matches a third field in the database, thereby acting as sort of a password protection preventing random users from updating the database.

So, something like this:

"UPDATE table SET COLUMN1 = '" . $_POST["COLUMN1"] . "' WHERE COLUMN2 = '" . $_POST["COLUMN2"] . "' IF password = "xyz"";

Any thoughts?

[Pig]

Do a "AND" instead of if, and then do mysql_affected rows to see if anything was changed.

[Spire2000]

I'm not sure I follow. Using "AND", wouldn't the row get updated whether or not the password was entered since I would already have the password entered into the table and I just wanted to check for it?

I'm sure I'm just a little confused here.

[Spire2000]

Solution found. I simply had script check for the submitted password field, and if it didn't equal my set password, not update was done.

Thanks for your help.

[Pig]

Using AND is simpler. If you use it in the WHERE clause, it will only update if column two AND the password are correct.