RE: [PHP] Count
| From: | Jon Haworth | Date: | Mon, 25 Feb 2002 09:59:30 +0000 |
| Subject: | RE: [PHP] Count | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-86062@lists.php.net to get a copy of this message | ||
Hi,
> 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;
Visual?
What do you mean? You want to display the results on the page? In that case,
just step through using mysql_fetch_array and echo each row.
Or did you want something else?
Cheers
Jon