danTheWalker

Hi Everyone I'm Dan, Ive recently been assigned the task of producing an online app that will allow a collection of tennis players to log in using a single user log-in (this is to simplify it for them) and to select a radio button corresponding to a time, a row of buttons for each player in a table. allowing the users to easily visit the page and see who will be playing at what time. This will be displayed for the Friday of every week and additional expansion is to include functionality to move between weeks and set status for say every Friday for the entire year and if a players status is still set to null then to send them an email prompting them to update their status plus telling them who is playing when. My problem is I have very little experience programming in PHP and am just scratching the surface. The way in which I have it planned so far is to have: a Tennis Planner db(database) a players table containing each players name, a unique ID (and possibly time var?) In the confusion of my understanding however I'm at a loss as to whether the right way to go would be creating a new table for each date which will then store a value for each players time variable which can be stored and retrieved to display the relative setting for each player or ??just lost here? The way i intend to handle the time setting conundrum is simply set this time variable for each player to an int between 0 and 7, each corresponding to a array of values as follows: Time | Value null = 0 4.30 = 1 4.45 = 2 5.00 = 3 5.15 = 4 5.30 = 5 5.45 = 6 6.00 = 7 And using a function to update this page table with the correct radio button settings. Then when a player logs in and changes it they hit submit and the new variable settings for that date are stored. All this is all a bit of a jumble in my mind however and I'm just doing my best for a novice level I'm not a completely novice programmer, i have a stable understanding of OOP concepts, plus I have a deeper understanding of ECMA scripts from AS2 and the foundation seems pretty similar from what I can tell so far however what I would most like is if someone can hit me up on any of the IM's and talked to me a little more fluently about the whole think. Any help, guidance and/or advice is much appreciated Thanks in advance Daniel Walker