Justtechjobs.com Find a programming school near you






Online Campus Both


php3-list | 2000051

Re: [PHP3] select and ENUMs From: Richard Lynch (richard <email protected>)
Date: 05/15/00

In article <391E49CD.1676863E <email protected>>, curtpdx <email protected> (curt)
wrote:

> Is there a default value that's the equivalent to a blank entry in title
> or isbn? I've tried a single space as a leading value e.g. first_ed

I dunno. What's in your data? Maybe you want "or $title is null" in there...

> ENUM(' ', 'y', 'n', 'p'), but that didn't change the result when trying
> to retrieve rows WHERE signed=y. Searching with both ENUMs ...WHERE

Using 'like' with ENUMs is probably silly: 'like' does a text comparison
with Regular Expression pattern-matching; ENUMs are, by definition, a
limited number of discrete possible values:

> // start ENUMs
> if ($signed)
//> $searchstmt .= "signed like '%$signed%' and " ;

         $searchstmt .= "signed = $signed and "; 

-- 
Richard Lynch                | If this was worth $$$ to you, buy a CD
US Customer Support Director | from one of the artists listed here:
Zend Technologies USA        | http://www.L-I-E.com/artists.htm
http://www.zend.com          | (this has nothing to do with Zend, duh!)

-- 
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe <email protected>
To subscribe to the digest, e-mail: php3-digest-subscribe <email protected>
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin <email protected>