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

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

2009-02-15 Thread David Robley
revDAVE wrote: > Newbie question... > > > I have a search page with multi lines of search criteria: > > Name > Topic > Message > Etc... > > I'm hoping to get results based on what criteria I type - but I'm not > getting what I expect. I think it's just getting results where in addition > to ge