Unanswered: multiple row mysql inserts using checkbox
I am trying to figure out how to populate a "main" db from a "limbo" db. I can query the "limbo" db and using printf, have a nice page output of records. What I want to do now is, those records that are "checked" using a checkbox, are the only ones that will get processed into the "main" db.
I do a basic mysql query from the source db easy enough and get the desired php page with a checkbox:
$result = mysql_query("
ORDER BY for_id
No problems there. What I cannot mentally get a handle on is how to insert all the items that are checked off into the destination table. I have done insert hundreds of times with "single" form pages. I'm thinking I have to "loop" an insert, but I have failed on getting on to work properly.
Thanks!!! Then reading the answer, it's almost like.. duh! Bahahhaha..
Here's a somewhat simplified solution that I implemented. Two loops; one to build the initial array and web page form for the user from a source table to approve items with a radio button, then the another, as suggested, to evaluate what has been approved and process that record into the destination table.