Pass data through multiple pgs
Please go the following site: [login to view URL]
I need to have the forms programmed so the data is written to a mysql database. Next when the user submits I need two copies of the data in a nice format to be emailed to the user and another copy to another party.
On the first page there is a drop down to select type of service - the item Auto, represents the click through. I need all forms and text fields data to be written as a session for that user and also generate a Reference number as seen on the 3rd step "Reference:(REF_#}". Also when a user enters a zip code I need that zip code to load related city, as seen on step 2. So all city's and states must exist in a table sql table.
Also a page should be written in html to have all records show up by name and date submitted, then link from their name to a page with full record outputted. This page should be a secure login page. Last all fields should be required with a alert in html/css that highlights this after they hit submit.