Build an web-based form with dynamic questions

Question

Hi,
I would like to build an web-based form with about 15-200 questions for an small clinic of my friend. Patients should fill that form from home or from on an computer that stands in his waiting room. After filling the form the doctor should see the corresponding result/feedback pages in his treatment room.

It should be easy to modify, add or remove some questions. My friend should do these modifications on his own. So this process should be safe for luser and free of complicate looking source code.
Do you know any libaries or programs which could help to administrate the questions ("decision tree" ?) ?

How would you store the data? I think the best way is to store the questions in an database (mysql). How would you structe these database to be flexible for changes?

I am in the beginning, so I don't know which programming language I will use later.

Thank you very much in advance for your help.

Answer 1

It seems you are kind of talking about a Survey form. Start from designing the form in HTML and styling it with.CSS to appear nice then you can use JavaScript for form validation or use PHP if you want PHP to handle form validation , still use PHP for the form processing and storage into the database. Use MySQL as the database.as time goes by, you could make it a CMS (content management system) for ease of adminstration.