I have a high school sports website with football schedules and more for each school in our state. What I need is someone to write code to access 4 tables in our database based on a school's ID.
Information: 1 entry per school
Schedules: multiple entries per school
Advertisements: multiple entries per school
Articles: multiple entries per school
Each page should be accessible by a link with the id in the URL.
The database is already setup but may need to be improved. This is the first step in a larger database driven section of the site. The schedules are already a functional part of the site but I would prefer someone to write the code in one uniform manner. Example page here:
[url removed, login to view]
Time wise as soon as possible would be good.
Full details will be available to the winning bidder