Re: [PHP-DB] NULL to 0 result

2010-12-15 Thread Richard Quadling
On 14 December 2010 21:53, Ron Piggott ron.pigg...@actsministries.org 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` =

Re: [PHP-DB] NULL to 0 result

2010-12-15 Thread Chris
On 15/12/10 21:42, Richard Quadling wrote: On 14 December 2010 21:53, Ron Piggottron.pigg...@actsministries.org 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

[PHP-DB] NULL to 0 result

2010-12-14 Thread Ron Piggott
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_include` Ron The Verse of the Day “Encouragement from

Re: [PHP-DB] NULL to 0 result

2010-12-14 Thread Bastien Koert
On Tue, Dec 14, 2010 at 4:53 PM, Ron Piggott ron.pigg...@actsministries.org 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