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
--
---------------------------------------------------------------------
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
