SELECT * from some_table WHERE some_field IS NULL;


Andrey Hristov
IcyGEN Corporation
http://www.icygen.com
BALANCED SOLUTIONS

----- Original Message ----- 
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 4:09 PM
Subject: RE: [PHP] Getting my head around nulls.


> >I wish the rest of the world saw it that way! But not so...
> 
> That's what capitalism does for you -;)
> 
> >You may want to look at MySQL's IS_NULL function for retrieving data.
> Other
> >than that, I don't have any good advice. It seems that if you retrieve a
> >NULL from the database and try to assign it to a PHP variable, that
> variable
> >gets destroyed. AFAIK, yes, you need a bunch of data checks, both putting
> >data in and pulling it back out.
> 
> Strange, I did a search on is_null in the MySQL manual (ver 3.23.40 .pdf)
> and got no nits on is_null.  Could you provide example of its use.
> 
> Neb
> 
> 
> -- 
> 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]
> 
> 


-- 
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]

Reply via email to