Sorry but I am stumped, I have written a php program that uses a form to submit the fields that are written into the record of a file, and it writes those records just fine. Now I want the same program to be used to retrieve the MYSQL table row to be changed but not sure how to go about it. Before I get started down the wrong path, can I just execute some php code before the page is loaded, to qry for the record that I want to maintain, and since my fields are the exact names from the form that are in the row, will they just come up in the form and then they can be changed and the submit will update the table instead of do an insert? Or do I have to move all of the row fields one at a time into $formvars[...] to get them connected to the form?
Any words of wisdom or samples to follow? This is actually a file maintenance program to create a 1 record table of control fields. So is there a simple way to display a form, create the table and insert the 1 row, then using the same program retrieve that same row and put the fields into the form the changed then with submit rewritten back to the table row?