Monday, 12 August 2013

How to get mysql data by group and count of row like this

How to get mysql data by group and count of row like this

+-----+-----+----+
| id | time |
+-----+-----+----+
| 1 | 8 4 2013 |
| 2 | 8 4 2013 |
| 3 | 9 4 2013 |
| 4 | 6 4 2013 |
+-----+-----+----+
I want to show result like this
At Date 8 4 2013 you have 2 row
At Date 9 4 2013 you have 1 row
At Date 6 4 2013 you have 1 row
please help me i dont know how to do this, i am new to php mysql please
give me full code to do this. please just don't write query i want full
code. please.

No comments:

Post a Comment