I'm looking at a routine / script to create the fixtures like
team 1 vs team 2
team 3 vs team 4
team 5 vs team 6 etc
Build the script round the query.
PB
-----
On 8/19/2010 12:07 PM, Tompkins Neil wrote:
I'm looking at a routine / script to create the fixtures like
team 1 vs team 2
team 3 vs team 4
team 5 vs team 6 etc
On Thu, Aug 19, 2010 at 3:44 PM, Peter Brawley<
peter.braw...@earthlink.net> wrote:
I'm tasked with generating a list of fixtures from a table of teams,
whereby
each team plays each other home and away. Does anyone have any
experience
generating such information using MySQL ?
Basically ...
select a.id,b.id from tbl a join tbl b on a.id<b.id;
union
select a.id,b.id from tbl a join tbl b on a.id>b.id;
PB
-----
On 8/19/2010 9:12 AM, Tompkins Neil wrote:
Hi,
I'm tasked with generating a list of fixtures from a table of teams,
whereby
each team plays each other home and away. Does anyone have any
experience
generating such information using MySQL ?
Thanks for any input.
Regards
Neil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org