I started developing a site for my Local Amateur Rugby League generally where they could post news etc.
One of the new functionalities they would like is a system where they can add fixtures for each of the age groups.
U15s - 3 Leagues of 8 Teams
u14s - 4 Leagues of 8 Teams
u13s - 4 Leagues of 8 teams.
Currently I have implemented a system where by every tuesday they add the fixtures together with referee information, kick off times etc.
This works fine and whilst I am sure it probably isnt implemented the correct way it works.
To follow on from that they would like a searchable results page as well, problem is that when the next weeks fixtures are added, the previous weeks are deleted.
Is there a way that I can have the information in Fixtures moved to a Results table and the Fixtures table emptied ready to have the following weeks fixtures entered?
I really would appreciate any help with this as I am only new to PHP, MYSQL and its one of those things where you are involved with a group and are asked to build a site, then they want more and you find it difficult to say no.
Anyone any Ideas?
The site is here - http://www.nwc13-15arl.co.uk
The admin panel can be found here http://www.nwc13-15arrl.co.uk/admin
Many thanks in advance