Sorry - just realised I put this in the PHP forum, I meant to put it in the mySQL one! But anyway now I'm here
We just had a quick rethink - this is plan two
We need to be able to search for Team but NOT Division together with Season but NOT League.
So people can search for Mens II (the Team) and Winter '00 (the season) and get the results for them. If they want they can just search for Mens II but they'll get about 5 sets of results.
Please make it as simple as you can as I'm still new to this stuff. Thanks for your help!