dynamic form from mysql
Posted: Mon Feb 28, 2011 9:09 pm
I need to create a form from mysql to list a series of usernames and a few text fields for each. Then process them to a table with the results. I can do this creating an individual form for each user but thats not efficient. Here is a sample layout.
form layout
row1 {userid = hidden, Name = label, textfield, anothertextfield }
row2 {userid = hidden, Name = label, textfield, anothertextfield }
row3 {userid = hidden, Name = label, textfield, anothertextfield }
row4 {userid = hidden, Name = label, textfield, anothertextfield }
process each one with there own insert
insert into ~~~~ userid, textfield, anothertestfield
not sure how else to explain it. I thought about dynamically joining the text field like userid_textfield, userid_anothertextfield but that seems cumbersom.
There could be as few as 2 or 3 and as many as 100 users to process. Any help and examples would be much appreciated.
form layout
row1 {userid = hidden, Name = label, textfield, anothertextfield }
row2 {userid = hidden, Name = label, textfield, anothertextfield }
row3 {userid = hidden, Name = label, textfield, anothertextfield }
row4 {userid = hidden, Name = label, textfield, anothertextfield }
process each one with there own insert
insert into ~~~~ userid, textfield, anothertestfield
not sure how else to explain it. I thought about dynamically joining the text field like userid_textfield, userid_anothertextfield but that seems cumbersom.
There could be as few as 2 or 3 and as many as 100 users to process. Any help and examples would be much appreciated.