Count
| From: | Sven Jacobs | Date: | Mon, 25 Feb 2002 09:44:24 +0000 |
| Subject: | Count | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-86060@lists.php.net to get a copy of this message | ||
hey
Again a small question forgive me but it's monday and the brain is still
working on sunday :-)
I want to make this sql query visual does anybody have any idea :-)
SELECT date_format(t_timestamp_opened,'%Y %m %d'),
count(date_format(t_timestamp_opened,'%Y %m %d')) FROM crm.ticket group by
date_format(t_timestamp_opened,'%Y %m %d') order by t_timestamp_opened;
+--------------------------------------------+------------------------------
---------------------+
| date_format(t_timestamp_opened,'%Y %m %d') |
count(date_format(t_timestamp_opened,'%Y %m %d')) |
+--------------------------------------------+------------------------------
---------------------+
| 2002 01 15 |
1 |
| 2002 01 22 |
1 |
| 2002 01 23 |
3 |
| 2002 01 25 |
2 |
| 2002 01 29 |
2 |
| 2002 02 01 |
1 |
| 2002 02 06 |
2 |
| 2002 02 11 |
1 |
| 2002 02 12 |
1 |
| 2002 02 15 |
1 |
| 2002 02 22 |
2 |
+--------------------------------------------+------------------------------
---------------------+