Re: incrementing a number from a text file
| From: | Richard Lynch | Date: | Tue, 15 Mar 2005 16:24:25 +0000 |
| Subject: | Re: incrementing a number from a text file | ||
| References: | 1 2 3 4 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-210820@lists.php.net to get a copy of this message | ||
BAD (probably):
>>>> Select blablabla FROM t1,t2,t3
>>>> WHERE customers LIKE '%$s%'
>>>> OR name LIKE '%$s%'
>>>> OR domain LIKE '%$s%'
>>>> OR email LIKE '%$s%'
>>>> OR log LIKE '%$s%'
>>>> AND t1.id = t2.t1_id
>>>> AND t1.id = t3.t1_id
GOOD (usually):
>>>> Select blablabla FROM t1,t2,t3
>>>> WHERE (customers LIKE '%$s%'
>>>> OR name LIKE '%$s%'
>>>> OR domain LIKE '%$s%'
>>>> OR email LIKE '%$s%'
>>>> OR log LIKE '%$s%')
>>>> AND t1.id = t2.t1_id
>>>> AND t1.id = t3.t1_id
Note parentheses added around OR expressions.
--
Like Music?
http://l-i-e.com/artists.htm