Return value of 0 from MySQL query if empty

Asked Jan 01 '15 at 01:18

Active Jan 01 '15 at 01:33

Viewed 37 times

I use this query to get a value for a range of months. For example, January 1.10, February 2.37.

"SELECT SUM(DISTRIBUTED_AMOUNT / EXCHANGE_RATE)
FROM royalties
WHERE DATE BETWEEN '".$datemin."' AND '".$datemax."'
GROUP BY DATE 
ORDER BY DATE ASC"

Is there a way to return a value of 0 if there are no rows within a certain month?

asked Jan 01 '15 at 01:18

Michael St Clair

Is it possible there is no data at all for a month? – Bohemian Jan 01 '15 at 01:27
Yes, there are some months that will not have a single row in the table, so no data for that month – Michael St Clair Jan 01 '15 at 01:28
Do you query one month at a time? – Bohemian Jan 01 '15 at 01:34
No, just the one query returns all of my values – Michael St Clair Jan 01 '15 at 01:35

0 Answers0