Regretably I cannot help with the script syntax you are using, because I am not familiar with it. I would still add the survey ID to the where clause in case this respondent should take more than one...

You should just have to present the survey similar to a user taking it for the first time, and execute a select sql statement similar to the one I wrote in my last response for each question, to...

If I understand you correctly, the answers table has an automatically generated ID when a respondent fills in an answer, along with their name as we discussed before. So, to update you would first...

Ah yes, you should also have a primary key for your answer table to retrieve and update any particular answer (this is why I put a numeric primary key field in every single table I create whether I...

Personally, I doubt that you can justify the time it will take to learn about data driven web sites for one site with 30 pages that may change only occasionally. But if you have to, or you're just...

I think you would need an AID field in the Survey_question table to link possible answers to survey questions and an SID field in the Question_Answer table to relate your answers to surveys. If the...

Assuming you are not keeping any information about the person taking the survey, it sounds like a 3 table relational database. The first column would be your survey questions. The 2nd table would be...