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]