Morten Nielsen wrote:

> It is because it is a search function where a user can enter an ID, NAME and
> ADDRESS to search after. If one of the fields are empty it should use the
> wildcard.

    Then while you're constructing the search string, evaluate whether that
field is empty or not (isset() should work fine for this).  If it's empty, stick
'%' in the string, otherwise use the variable contents.

--
W | I haven't lost my mind; it's backed up on tape somewhere.
  +--------------------------------------------------------------------
  Ashley M. Kirchner <mailto:[EMAIL PROTECTED]>   .   303.442.6410 x130
  IT Director / SysAdmin / WebSmith             .     800.441.3873 x130
  Photo Craft Laboratories, Inc.            .     3550 Arapahoe Ave. #6
  http://www.pcraft.com ..... .  .    .       Boulder, CO 80303, U.S.A.




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to