RE: [PHP] Re: How to output a NULL field?
| From: | David Stoltz | Date: | Thu, 27 Aug 2009 12:37:58 +0000 |
| Subject: | RE: [PHP] Re: How to output a NULL field? | ||
| References: | 1 2 3 4 5 6 7 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-297355@lists.php.net to get a copy of this message | ||
You're a genius - that works!!!!!
-----Original Message-----
From: Bastien Koert [mailto:phpster@gmail.com]
Sent: Wednesday, August 26, 2009 2:02 PM
To: Andrew Ballard
Cc: Shawn McKenzie; php-general@lists.php.net; David Stoltz
Subject: Re: [PHP] Re: How to output a NULL field?
One option then, might be to format the result with SQL using a CASE
WHEN THEN statement or ISNULL / IFNULL to set it to empty string
--
Bastien
Cat, the other other white meat