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,
Paul DuBois, paul@stripped