On 15/12/10 21:42, Richard Quadling wrote:
On 14 December 2010 21:53, Ron Piggott wrote:
What change is needed to this query so if “currently_in_rss” is NULL it will be
assigned a value of 0
SELECT `reference`, COUNT(`reference`) AS currently_in_rss FROM
`ministry_profiles` WHERE `rss_feed_
On 14 December 2010 21:53, Ron Piggott wrote:
>
> What change is needed to this query so if “currently_in_rss” is NULL it will
> be assigned a value of 0
>
> SELECT `reference`, COUNT(`reference`) AS currently_in_rss FROM
> `ministry_profiles` WHERE `rss_feed_include` = 1 GROUP BY `rss_feed_incl
On Tue, Dec 14, 2010 at 4:53 PM, Ron Piggott
wrote:
>
> What change is needed to this query so if “currently_in_rss” is NULL it will
> be assigned a value of 0
>
> SELECT `reference`, COUNT(`reference`) AS currently_in_rss FROM
> `ministry_profiles` WHERE `rss_feed_include` = 1 GROUP BY `rss_fee
Thanks, Ron
--
-Original Message-
From: Andrés G. Montañez
To: ron.pigg...@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
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