PHP Query for Counting by Date

Asked Apr 06 '12 at 23:57

Active Apr 07 '12 at 00:28

Viewed 96 times

I have a database table called books

books ('id', 'sku', 'date_added')

where date_added is DATETIME.

I need to run a query to find all books by count added last month. Now i can do it and get a list but for dates nothing was uploaded, i would need a 0. How do i achieve this?

Also what query would give me a count of books uploaded by month?

edited Apr 07 '12 at 00:28

Ankit Sharma

3,923
2
29
49

asked Apr 06 '12 at 23:57

daydreamer

Look here: http://stackoverflow.com/questions/1138190/mysql-query-to-calculate-the-previous-month – René Höhle Apr 07 '12 at 00:01
I am not able to get 0's for days nothing has been added. I could not find the solution on that link. – daydreamer Apr 07 '12 at 03:32
Look here: http://stackoverflow.com/questions/2157282/generate-days-from-date-range – fancyPants Apr 07 '12 at 09:09

PHP Query for Counting by Date

0 Answers0