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