Re: NULL to 0
| From: | Ron Piggott | Date: | Sun, 18 Jul 2010 13:44:52 +0000 |
| Subject: | Re: NULL to 0 | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47266@lists.php.net to get a copy of this message | ||
Thanks, Ron
--
-----Original Message-----
From: Andrés G. Montañez <andresmontanez@gmail.com>
To: ron.piggott@actsministries.org
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] NULL to 0
Date: Sat, 17 Jul 2010 23:20:20 -0300
SELECT
IFNULL(SUM(
my_Bible_trivia_knowledge_questions_answered.score),
0) AS total_score,
IFNULL(my_Bible_trivia_knowledge_profile.questions_answered, 0)
AS questions_answered
In these cases you must use the IFNULL function, for testing the value.
--
Andrés G. Montañez
Zend Certified Engineer
Montevideo - Uruguay