I have a situation where I need to do select on my mysql db.
Here is what I am trying to do
Select * from table_name where col1=1 and col2=1 and col3=0
But this refuses to work.
If I change the above to this.
Select * from table_name where col1=1 OR col2=1 and col3=0
What I get is all rows whether or not col3 is 0 or 1.
I am confused ☹
Any help or guidance is very much appreciated.
Thanks in advance
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php