Re: [PHP] Re: Simple Search Logic Issue...

2009-02-17 Thread David Robley
Bastien Koert wrote: > [snip] >> >> >> >> For example LIKE 'c' will only match a field that contains just 'c' >> >> LIKE '%c' will match a field starting with 'c' and containing any number >> of characters >> >> [/snip] >> Cheers >> -- >> David Robley >> >> Make like a banana and split. >> Today i

Re: [PHP] Re: Simple Search Logic Issue...

2009-02-16 Thread Bastien Koert
[snip] > > > > For example LIKE 'c' will only match a field that contains just 'c' > > LIKE '%c' will match a field starting with 'c' and containing any number of > characters > > [/snip] > Cheers > -- > David Robley > > Make like a banana and split. > Today is Sweetmorn, the 46th day of Chaos in t

Re: [PHP] Re: Simple Search Logic Issue...

2009-02-15 Thread revDAVE
On 2/15/2009 3:32 AM, "David Robley" wrote: > If you are using that syntax, I'd suggest echoing your query to make sure > that it is as it should be; I'm wondering if you are actually enclosing > string values in single quotes in your query? Another part of the dw cs3 code uses switch - that se

Re: [PHP] Re: Simple Search Logic Issue...

2009-02-15 Thread revDAVE
On 2/15/2009 3:32 AM, "David Robley" wrote: > > LIKE '%c%' will match a field containing 'c' anywhere > > If you are using that syntax, I'd suggest echoing your query to make sure > that it is as it should be; I'm wondering if you are actually enclosing > string values in single quotes in your