[EMAIL PROTECTED] wrote:
Hi!
I need to use SQL to count some sequences. We have taken a short
snapshot of 1 year for people registered in programs. So we have data in
a table like so:
ID m1 m2 m3 m4 m5 m6 m7m8 m9 m10 m11 m12
The "m1", "m2", "m3" refers to month 1, month2, month3, etc.
The data fo
At 9:04 PM +1000 10/2/01, Bruce Collins wrote:
>Hello,
>Thank's for your interest Paul. I did a poor job
>of explaining my problem. Here is another go:
>For an athlete's first entry in the database I need a column
>value of 1. The second performance entry of the same athlete
>would have a value of
Bruce,
Why not just determine this number when you do a query? Why do you need to
have it be stored in the database?
It's easy to create a Perl (or probably PHP, but I really don't know PHP)
script to fill in such a column, too, but you would need to manually
maintain that. And right now I don
At 12:23 PM +1000 10/2/01, Bruce Collins wrote:
>Hello,
>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
>chronolo
