How can I get the count of orders placed from my database?

Posted by user1360564 on Stack Overflow See other posts from Stack Overflow or by user1360564
Published on 2012-07-04T08:09:15Z Indexed on 2012/07/04 9:16 UTC
Read the original article Hit count: 147

Filed under:
|

I am preparing a chart which will display the number of orders placed for a particular day in the current month and year. I wanted the count of orders placed for each day. I am showing the count of orders on the y-axis and the day on the x-axis. In my database, there is table called "order" in which order data is placed: order date, user_id, order_price, etc. For example, if on 4 July, 10 orders are placed, on 5 july, 20 orders are placed, and so on.

How can I get the count of orders placed for day of the current month?

© Stack Overflow or respective owner

Related posts about php

Related posts about sql