I have a table called team (team_id, team_name, win, loses, tie) and a game
table (game_id, game_date). How can I build displau in Coldfusion showing games
played orderred by best win records
I m thinking to desgin a relational table r_game_team that wud have score too
in it and have team_id and game_id
Is there any other way I should design the table?
Dan Bracuk - 29 Jul 2006 23:47 GMT
You seem to be on the right track. You might want to add another field for win lose or draw.