Manipulating Submitted Forms

Lisbon67

Hi All.
Here's what I'm trying to do.
I want to build a multi use form that has drop down options linked to my database. The options should be different for each logged in user, so user one would see options a & b, whereas user two would see options c & d.
I could have a drop down menu at the top with the users in there if an automatic selection is not possible.
I want hidden fields in the form so that new options open up depending on the answer given to a previous question.
I would also like to be able to edit the form (including the answers) after it has been submitted, and if possible, add extra questions to it depending on the answers previously given.
Something giving live access to the database is probably needed here.
I would like then to republish the form with a drop down menu letting the user pick which form they previously filled in, and automatically filling in all the questions they previously answered.

I'm not looking for someone to do the hard work for me, (I'd probably be told to get lost anyway 😃 )

All I need to know is......is such manipulation possible? If so, does anyone know of a good form script which would let me do this.
If anyone know any good tutorials on forms, that would also be appreciated.

As you can guess, I'm a bit of a newbie, so any help would be greatly received.

rgermain

Ok....
If I am understanding you correctly you would like a drop-down menu (1) to populate drop-down menu (2) depending on what is selected in 1? Yes this can be done, but not with PHP. PHP is a server-side language. All processing is done on the server. So once the page has been served up to the client the only way to change the information on the page is to have it resubmitted to the server for reprocessing. However, you can use javascript to accomplish this task.

Then if I am understanding you correctly, yes the rest can be done with php.

Good referance point would be www.php.net for help with writing php.
If you are looking for a script check www.hotscripts.com.

Lisbon67

Thanks for the reply rgermain.
You're right in thinking that I want menu 2 to reflect what was chosen in menu 1.
I've seen an example on a car website, where you could choose the make of the car in menu 1. This would then give you all the models from that maker in menu 2. There was then a third menu letting you pick the colour of the car. All three menus were effectively linked.
If javascript is the way forward, then I'll have to look at finding a script to start me off.
Thanks again for your reply.
As to my other question, is it possible to manipulate the results once they have been submitted?
One option I had thought of is to export the results in csv format. How difficult is it to re-import that data once it has been changed?
Any ideas anyone?