server validation to check form value with database

I am trying to set up a server validation to check whether a form value matches a value in the database before allowing the form to be submitted. I have done this before using the number validation, however this time I am using mysqli. Everytime I submit the form it fails (even though I am entering a correct value). I have attached the code.

I think you need parenthesis in your where clause.

This is what you have:
WHERE loginlevels.loginlevel=1 OR loginlevels.loginlevel=6 AND loginlevels.password=?

This is what you need:
WHERE (loginlevels.loginlevel=1 OR loginlevels.loginlevel=6) AND loginlevels.password=?

oops - school boy error, I have amended that.

However that isn't the problem. I echoed the recordset to make sure I was getting results - and I am but when I submit the form I just get the error validation. The form never submits even though I am using a matching password.

Your validation is set up to make sure there is no row returned. You have the maximum number of rows set to 0. If you want it to pass when a row is returned then the minimum should be set to 1.

That would do it ;) Thank you so much!