Posted by Richard Lynch on 03/15/05 18:24

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

• Next in thread: Re: [PHP] incrementing a number from a text file
• Prev in thread: Re: [PHP] incrementing a number from a text file
• Next in forum: Re: [PHP] PHP file as homepage?
• Prev in forum: Re: [PHP] php compiler
• Thread view: incrementing a number from a text file

[Reply to this message]