Re: Multiple select ?
| From: | Adam Royle | Date: | Thu, 01 Aug 2002 22:29:08 +0000 |
| Subject: | Re: Multiple select ? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20961@lists.php.net to get a copy of this message | ||
Try using parentheses inside your sql:
Select * from table_name where (col1=1 OR col2=1) and col3=0
Select * from table_name where col1=1 OR (col2=1 and col3=0)
They make a big difference, also helps to indentify what you're selecting when you come back to
the sql later.
Adam