[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
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 for 1 person might loo
Hello,
A solution to my problem:
"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 2. And so on."
has been posted by Paul Dubois:
ALTER TABLE tbl_name
ADD seqnum INT UNSIGNED NOT NULL AUT
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
ight now I don't understand the problem well enough to
convince me that such maintenance would be worthwhile ...
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Bruce Collins [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 02 October, 2001 07:04
To: [EMAIL PROTECTED]
Subject: Cou
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 2. And so on.
I need to apply this retrospectively t
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
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
chronological order. Have been trying with PHP
but I am very mu
