On Mar 15, 2005, at 11:24 AM, Richard Lynch wrote:
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.
I see. Thanks for the info.
--
Kurt Yoder
http://yoderhome.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
