¡@
php Programming Glossary: goalsagainsthow to output a standings table on the fly from a mysql table of football [soccer] results? http://stackoverflow.com/questions/8009379/how-to-output-a-standings-table-on-the-fly-from-a-mysql-table-of-football-socce want here is the list of result. id hometeam goalsfor goalsagainst awayteam 1 Inter Milan 3 1 FC Barcelona 2 FC Barcelona.. this select team count played count case when goalsfor goalsagainst then 1 end wins count case when goalsagainst goalsfor then 1.. when goalsfor goalsagainst then 1 end wins count case when goalsagainst goalsfor then 1 end lost count case when goalsfor goalsagainst..
|