[EMAIL PROTECTED] (Mark Charette) wrote: > Actually, if you want to return all, just drop the "where" clause > completely.
but thet you have to check the input: normally you would have: select blah from table where field like '%something%' if nothing if selected you just insert a % on something's place select blah from table where field like '%%%' and no check on input is needed (AKAIK). -- Henrik Hansen -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]