Yeah, its all done and im really proud of the end result – i will post some screenshots up soon (can’t put up a link cos its being used by my end user and contains private data).
It’s a PHP based interface, using MySQL acting as the online database. The project was designed to allow the user to add pupils from year 3 to 8 to the database and give them scores for the sporting events they had participated along with selecting the best 4 events from drop down query lists which, once selected, the total points from those 4 events was calculated and displayed.
The system allows the user to delete pupils, move a whole year group up to the next year, delete a year group and several other functions.
I have learnt alot more about what PHP and MySQL can do, especially when combining them together!