Proper syntax

[Lionel]

I am trying to do an insert in database only if all conditions are met. But the below is inserting no matter what. What is wrong in there?

Thanks.


if ( $_POST["type"] == "rate" and ($_POST["rate"] != "" or $_POST["rate2"] != "" or $_POST["rate3"] != "" or $_POST["rate4"] != "" ))
{
do the db insert
}

else ...

[Adrian Schneider]

If it is inserting then all your conditions ARE being met.. :p

I'm thinking you probably want to replace those ors with ands? That would ensure all the fields have been filled out, and type is equal to "rate".

[Lionel]

OK I will try "AND" because conditions were not met.

[Andrew]

OK I will try "AND" because conditions were not met.
If all of your variables need to be set then just use AND instead of OR. Right now it's seeing if "type" and "rate" are set - If either of them isn't it looks to see if "rate2" is set OR if "rate3" is set OR if "rate4" is set to fulfill the statement. That make any sense ?