Re: Calculate
| From: | Luis Mirabal | Date: | Tue, 16 Mar 2004 16:29:03 +0000 |
| Subject: | Re: Calculate | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-180564@lists.php.net to get a copy of this message | ||
from sql?? if you are doing:
select ... count(date) ...from ... where ...
do:
select ... count(date) ...from ... where ... group by date
luis.
"Tommi Virtanen" <mailinglist@gwad.net> escribió en el mensaje
news:6.0.0.22.2.20040316142818.025a3ea8@62.165.180.66...
> Hi!
>
> How I can calculate following:
>
> I have table:
> id(int) start_date(date) end_date(date)
> 001 2004-03-10 2004-03-12
> 002 2004-03-27 2004-04-02
> 003 2004-04-05 2004-04-06
>
> Total count of date is 12. But how I can calculate count of
> date per month?
>
> regards,
>
> gustavus