Ok this is a issue i've been wrestling with for a few days now, and just for the life of me can not wrap my head around this.
What I am wanting to do is Pull records from the MYSQL DB and create a dynamic form showing those records + fields so a user can update them.
Now I can pull and place in the form with no problem. The problem comes in when saving the changes.
There could be 50+ records that are pulled in from the DB. So that would create
<input id="Name1"><input id="URL1">
<input id="Name2"><input id="URL2">
So obviously from record one, Name1, and URL1 are from that record.
So how can I dynamically account for a ever changing list of veriables that come in and keep all the fields linked to the right record. Meaning so I don't have URL2 being updated for record 1 and so forth.
Since this is one huge form, i'm at a loss.
I'm wanting to do it this way, because before I had each record in it's own form. Which as you could guess required a Submit button for each field. And my users were a little annoyed with that setup. So one form so they can change all data that needs changed and update it all at once would be great.
Any assistance would be greatly appreciated.