I found
this node as a start, but would like to simplify the process of matching up all fields and field values more dynamically.
I have a form that will survey visitors of about 50 questions. Each form field has a name that corresponds to a column in our database. In jeffa's approach, he created an array of fields and a corresponding array of field values which is used to generate the INSERT statement. Great start, but is there a better method. If I used CGI's param() to obtain a list of all fields submitted, could I go from there? 2 problems, I'd probably get a series of additional fields (hiddens, submits, etc)? and also am unsure how to deal with multi-valued params.
Any suggestions?