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 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_

Re: [PHP-DB] NULL to 0 result

2010-12-15 Thread Richard Quadling
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

Re: [PHP-DB] NULL to 0 result

2010-12-14 Thread Bastien Koert
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

[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 God’s