
September 15th, 2004, 03:06 PM
|
|
Contributing User
|
|
Join Date: Sep 2004
Location: New York City
Posts: 49
Time spent in forums: 3 h 57 m 38 sec
Reputation Power: 4
|
|
|
Strategy on new project - help please
I am planning out a new project and I am having trouble seeing the light at the end of the tunnel. I am hoping that some of you experts can help put me in the right direction before I get going at writing the complete script.
Here is the project:
- The same number (56875907) is distributed to 200,000 people. Each day the 200,000 people are going to go to a website and enter the number (56875907) into a form. Two things can happen after the form is submitted. 1) They are accepted or 2) They are declined.
Scope of the project:
- Only 1 person can be accepted per day.
- Each day over a 3 month period 1 person will be accepted per day.
- Acceptance will not be set on a first come first serve basis each day. The reason for this is so a person does not enter at 12:01AM each day and get to be the acceptee each day for the 3 day period.
- The underlying database will need to have a time parameter. I am not sure how to do this. The script will need to check the current date and time from the submitter. Maybe the database will contain a row for each day for the duration of the 3 month period and maybe each row will contain the date and a unique random or incremented time that will be the commencement for the one acceptance to be submitted. This way no one will know what time of the day the one acceptance will be allowed.
- However, I wouldn't want the random time parameter to be 11:59PM because then there is the possibility of no acceptee for the day. Obviously if no one submits throughout the day that can also be the case. This will not happen though.
- The script would need to also check if the once per day acceptance has been given out already before checking if the time paramater has passed.
- Lastly all information whether pass or fail will be submitted to a table in the DB.
Your thoughts or comments would be much appreciated. This project is purely at a conceptual level at the moment. I like to plan my projects out before writing code.
Thanks
|