Either I'm having a severe case of brain fade or I'm asking for the impossible... I fear it's the former. At any rate, I need some direction.
In a nutshell: I've extracted data from a DBase and need to edit/update one single field of that particular table then manipulate the remainder of the data to use as fodder for New Rows on another table. No Problem when done singularly.
However! Now I need to choose/edit multiple rows, each containing the single field mentioned above and use the data from each row to construct the New Rows to be inserted into another DB table: As a "block"... en mass.
I've got checkboxes to select the various rows but am having a bear of a time extracting the passed values to do the actual work.
The checkboxes pass an array of comma separated values for that particular row. I felt like that would be the easiest to work with and it keeps associated values together. But, I cannot for the life o' me figure out how to extract usable data so it can be used in a MySql update query.
Below is the data that is being passed (abbreviated): The first value is the rowID, second is another ID and the third is a dollar amount that will be updated. As I mentioned, each row (if selected to edit) will pass one array. The example shows 3 rows.
Array ( [0] => Array ( [0] => 3,1003,13.50 [1] => 6,1006,10.85 [2] => 9,1009,13.55 ) )
I'm not terribly worried about the New Row problem as I think I've just figured out how to compute the values needed and insert that data as a single row instead of (possibly) 30 rows. But, the updated account balance (dollar amount) Must Be Done in conjunction with all other inserts/updates.
Would really appreciate someone sending me in the right direction.
