I have a football pool website. It uses pages generated by a 3rd party software. I currently have my site so it is user authenticated through mysql database. I have a page where players make their picks for nfl games on a week to week basis. Right now, they choose their name from a drop down list, make their picks and submit. When they submit, I get an email with their username(from dropdown list), password which they provide and their picks. I take the emails and import them using the 3rd party software and it generates all the webpages for me, then I upload them.
Now this is what I want.... I want for them to be able to submit their picks, have it stored in mysql database as well as send me the email, and to have them be able to go back to the page where they make the picks and to have their picks they made still visible.
Also would like a page made that once a player makes their picks, when they goto it, it lists columns with USERNAME|GAME 1|GAME 2|...GAME 16| TIEBREAKER|, where it would show their name under USERNAME, and the team name that they pick under each game. Extra peice in this puzzle, this page would be on a time frame basis, where at a certian day/time the teams would become visible, before this day/time, the teams would be denoted with a "-".
I will provide the main form page so most of the work is already done, just need the php script to get it to post to mysql, and for it to be recalled when the user goes back to the page. The second page would have to be created and can be generic.
If you are interested in this project which I would think would be an easy one for the php/mysql savvy... then please let me know. Thank you,