for all php guru's

[rIGO]

i have a database with the following columns:

id, datetime, venue, competition, hometeam, awayteam, homeresult and awayresult.

basically it will have fields such as:

1, 2002-01-11 15:00:00, Sliema, Div. 1, Sliema, Valletta, 2,0
2, 2002-01-11 16:45:00, B'Kara, Div. 1, B'Kara, Hibs, 1, 1

i want to get the info on the database to be viewed in a table according to the points obtained from every result. therefore if homeresult > awayresult then, hometeam gets 3 points and awayteam gets 0 points. if they equal they get a point each.

the table must look like so:

squad, games played, games won, games drew, games lost, goals in favour, goals against, goal difference, points

the result using the fields shown above should be outputted like so:

Sliema, 1, 0, 0, 2, 0, +2, 3
B'Kara, 0, 1, 0, 1, 1, 0, 1
Hibs, 0, 1, 0, 1, 1, 0, 1
Valletta, 0, 0, 1, 0, -2, 0

is there anyway of someone can instruct me on how to do it step by step; or someone creates the code and posts it or sends it over to me pls 😃 thanks a lot for the help!

rIGO
[e-mail]

[rIGO]

nobody has an answer?

[jasper]

Why don't you...
1) SELECT * FROM table ORDER BY venue, datetime
2) Loop over the results
3) You start with the first team name:
4) Fill a few arrays or counters for games played, points scored etc and update this for every new row in the database for that team
5) When a row in the database contains a 'new' team name apparently you've got all records for the current team:
6) Output a row to the browser containing the current array or counter totals
7) Reset the counters
8) Goto 4) for every 'new' team name until all rows are done.