This is a contest entry form and survey that will be embedded in a page on a linux server running php and mysql. Contestants can enter once every seven days. Deliverable included all php and HTML for form, any scripts needed for field validation, and file to create php table(s). Formatting should be simple, generic and clean, we will tweak style. This is a rush job. Longer description follows.
This is a contest entry form and survey that will be embedded in a movable type-generated page on a linux server running php and mysql. Deliverable included all php for form, any scripts needed for validation, and file to create php table(s)
Fields ??" required*:
Home Address 1*
Home Address 2
Daytime Phone (to be used only to contact winners)
How many nights have you spent in Sonoma Country in the past 12 months?
How many total visits have you made to Sonoma Country in the past 12 months?
Are you planning a visit to Sonoma Country in the next year?
Would you like us to keep you informed about upcoming Sonoma Country events, special promotions and unique adventures via email?
Would you like to receive a 2008 visitors guide?
Email,phone, and zip fields should be validated for correct formatting, with simple error messages if invalid. Required fields should also generate error message if not present.
This needs to be a "sticky form" (values that were previously displayed will be set as the default value if an error is encountered).
We need a user configurable response message that will replace the form upon entry. Thanks for entering etc.
Important: user can enter once each 7 day period. SO we need to track time and date of entry, and if same user (determined by email addrress) try to enter again before seven days has elapsed, we need to return a configurable message that says "You may enter this contest every seven days. Please try again in a few days"