Re: incrementing a number from a text file

From: Date: Thu, 17 Mar 2005 01:19:53 +0000
Subject: Re: incrementing a number from a text file
References: 1 2 3 4 5  Groups: php.general 
Request: Send a blank email to php-general+get-210928@lists.php.net to get a copy of this message
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

« previous php.general (#210928) next »