Online form to Database/Excel and to Email

[FairyTale]

Hello there

I am hoping to find a solution to enable the following:

I want users to be able to go to an online enquiry form and select a Product/Service, some products are only available in some areas so the next field needs to be a drop box with only the areas slectable for the product/service.
The form needs to capture the users details and a date the service is required. When the user sends the form I need it to be stored in a database or excel sheet online somewhere (easy accessible) and also I need 2 x emails sending - 1 to me with ALL details from the form, and another to another email address wih only certain field from the form (the users details removed). The second email address is also conditional and is linked to the product and area selected.

Any help on this appreciated.
I am a basic coder only, not sure how to skin this cat....

Thanks!

[Medyman]

This is very common functionality. You'll need to utilize a server-side script (e.g. PHP, ASP). Below are some resources on creating such a form with PHP:

http://www.php-mysql-tutorial.com/wikis/
http://www.phpeasystep.com/phptu/8.html
http://www.htmlgoodies.com/beyond/php/article.php/3472441
http://www.developertutorials.com/tutorials/php/autoresponders-php-050525/page1.html

[Jammin Web Design]

I can creat an asp form that will send to you and the client, however I have never attemted to script one that will have different boxes depending on what is selected before hand. I'm sure I could figure this out though. Let me know if you would like help. MPhillips@JamminWebDesign.com

[FairyTale]

Thanks forthese pointers, is there anyone that can show m how to send form results to 2 separate emails addresses and toa database/excel as well as the two emails being sent having only specific form elements send to each....