Re: Odd PHP/MySQL Question
| From: | Julian Wood | Date: | Thu, 01 Mar 2001 21:24:35 +0000 |
| Subject: | Re: Odd PHP/MySQL Question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-42216@lists.php.net to get a copy of this message | ||
select count(*), year from students group by year;
on 3/1/01 12:07 PM, Kath at ranger@optonline.net wrote:
> I have a user database where a year has to be put in.
>
> Now, I want to compile a list of each different year and how many users are in
> that year.
>
> Is there a way to do this beyond coding for each year:
>
> SELECT * FROM students WHERE year = '1983' ?
>
> - Kath
>