Floyd Baker wrote:
>
> Hi.
>
> Hey I have been using a query in a search with prioritized criteria.
>
> In five different qualification fields, the first one filled in would produce
> the specific search. Name, City, Zip, (C)enter or (I)ndividual... If name &
> city empty and zip filled in, all that zip would appear. No problem.
>
> Now I have a situation where I do not want *all* zips to appear but only those
> belonging to either (C)enter *or* (I)ndividual. That is still no problem.
> That is simple 'zip' *and* 'type'.
>
> But now, if 'type' can be *either* (C) or (I), and we want to see *all* the
> zips, I get lost.
>
> It seems like it should be simple but I cannot make a third option of the input
> form to look for *either* in the same query. This is to be done for 3 out of the
> 5 fields in the same input form. I could probably do it with *lots* of
> if/thens but I'd rather not if possible otherwise.
>
> Can someone suggest something. Thanks much, in advance.
>
> Floyd Baker
>
Don't include the type field in the where clause.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
