From: Peter Brawley
Date: August 19 2010 5:48pm
Subject: Re: Fixture List generation using MySQL
List-Archive: http://lists.mysql.com/mysql/222597
Message-Id: <4C6D6E62.8020604@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit



>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.brawley@stripped>  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
>>>>
>>>>