-
ASP and SQL: Randomise?
I am doing a database on football (soccer) and contains several tables like LeagueTeam, LeagueTeam_1, Event, Player, Squad, etc...
I am wondering if there is a chance of randomising the fixture list? e.g.
1. LeagueTeam (for home team)
2. LeagueTeam_1 (for away team)
1. Newcastle V 2. Sunderland
1. Man Utd V 2. Liverpool
1. Sunderland V 2. Liverpool
1. Sunderland V 2. Newcastle
1. Newcastle V 2. Man Utd
1. Liverpool V 2. Newcastle
etc..
These fixtures would be stored in a table called Fixtures.
What are the procedures in randomising the League Teams (on ASP side not database) and producing a page containing the randomised fixture?
Help/advice would be greatly appreciated. :)
-
Hate to do this but <bump> :(