List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 2 2001 3:19am
Subject:Re: Counting Sequences
View as plain text  
At 12:23 PM +1000 10/2/01, Bruce Collins wrote:
>I have a mySQL database with a large table of
>athletic performances where every athlete has
>a row for every performance. My problem is to
>make a column which is a sequential count of
>each athlete's performances. The table is in
>chronological order. Have been trying with PHP
>but I am very much a beginner.

What do you mean by sequential count?  You want
to know how many records you have for each athlete?

SELECT name, COUNT(*) FROM table GROUP BY name

will give you that.  If that's not what you mean,
please specify.

Paul DuBois, paul@stripped
Counting SequencesBruce Collins2 Oct
  • Re: Counting SequencesPaul DuBois2 Oct