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 >chronological order. Have been trying with PHP >but I am very much a beginner. >Thanks, >Bruce.
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, [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php