Posted by mick white on 10/09/06 20:16

I have a mysql table which gives results of matches played:
mysql> desc PLG;
+----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+------------------+------+-----+---------+----------------+
| matchid | int(10) unsigned | | PRI | 0 | auto_increment |
| gamedate | date | YES | | NULL | |
| homeTeam | varchar(30) | YES | | NULL | |
| htg | smallint(2) | YES | | NULL | |
| atg | smallint(2) | YES | | NULL | |
| awayTeam | varchar(30) | YES | | NULL | |
+----------+------------------+------+-----+---------+----------------+

where htg = home team goals
where atg = away team goals

Is there a [simple*] way to create a league table?
(using PHP 4, mysql 3.22.32)
Any rhoughts?
Thanks.
Mick

[Back to original message]