Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2001092

Re: [PHP] Re: Search "all" in mysql From: Henrik Hansen (hh <email protected>)
Date: 09/30/01

charette <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: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>