Re: Getting my head around nulls.

SELECT * from some_table WHERE some_field IS NULL; Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS ----- Original Message ----- From: <Ben.Edwards@chase.com> To: <kjohnson@zootweb.com> Cc: <php-general@lists.php.net> 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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >