select count(*), year from students group by year;
on 3/1/01 12:07 PM, Kath at [EMAIL PROTECTED] 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
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]