I guess after the nonstop coding my brain has given up on me since I cannot figure this out. Could anyone provide me with an example that selects every row from a mysql DB table, and checks to see if each result is equal to 1? I am trying to add an error check to see if every row table named im_ready is equal to 1 and if not then it will stop the script. I cannot figure out a way to write this since a simple select query will not do the trick. Is there were foreach comes in or something? If you could please provide me with a code example that selects into from a DB and checks each individual value for each row and if one is not equal to 1 it errors but if all equal 1 it goes. I did use a SELECT count that compares the total rows to the rows that are ready and if they are equal it does what I want but the code looks messy and I am sure there is a better and cleaner way. Thanks.

What's the table structure? Any reason you can't do this?
SELECT COUNT(*) FROM table WHERE field != 1;

Yeah actually that is how I had originally programmed it. It works but is that the only way to go about it? I figured there was a simple built in php function that can do this a better way. If not then no worries and thanks for your reply.

It's a single query returning a single result. How much simpler do you want it to be? :)

It just looks messy the way I have it since I have to have one query counting how many are equal to one, and another query counting how many are in the room. Ok well you answered my question then thanks :)