Help saving araay data to database

Sorry it puts the in there when I pasted it.
It sort of got it working. It holds keeps the values of the prod_order but not assigned to the correct record.
It will save it as:
123, 18, 13, 4
124, 18, 11, 6
instead of:
123, 18, 13, 6
124, 18, 11, 4

$getem1 = $wpdb->get_results("SELECT * FROM category_assoc WHERE prod_id = '$lastID'");

 $array = array();
foreach ($getem1 as $res){
    $array[] = $res->prod_order;
}
$wpdb->insert("category_assoc", array( "prod_id" => $lastID, "cat_id" => $cats[$i] , "prod_order" => $array[$i] ), array('%s', '%s', '%s' ));

Ok its formatted now. I guess I need to match up the value of the prod_order to cat_id?

The $i is something I was trying. “prod_order” => $array[$i] works but the order is not correct. And “prod_order” => $array[] throws error. So its the formatting I have wrong. I guess its not correct. But at lease this was holding the values when it insert to the database. If it should be something else let me know.

I can change the integer type to.

category_assoc has these values: cat_assoc_id, prod_id, cat_id, prod_order

123,18,13,6 where 6 is the order. It is keeping the values but not in order. Product id 18 appear in category 13 in prod_order of 6 and it needs to remain that way. It will save it like this

123, 18, 13, 4. Either way I need to find a way to get multiple records back and reinsert them to the database in order.

if($edit)

	$wpdb->query("DELETE FROM category_assoc WHERE prod_id = '$lastID'");

	for($i= 0; $i < count($cats); $i++)

	{

		$wpdb->insert("category_assoc", array( "prod_id" => $lastID, "cat_id" => $cats[$i] , "prod_order" => => $order ), array('%d', '%d', '%d' ));

		$wpdb->query($catCategory);

	}

Should it go before or after this line
for($i= 0; $i < count($cats); $i++)

I will elaborate what the entire script currently does and how I am trying to revise it.

Each product id can appear in multiple categories. So there is the cat_assoc table. Each product id has (pdf) files associated with it so there is a addition_files table. When a product is edited and saved, it deletes the records associated in the categories and files tables. Then assignes the associations again. So assoc_id 123, prod_id 1, cat_id 2, prod_order 5
becomes assoc_id 124, prod_id 1, cat_id 2, prod_order 5. The problem I am having is if 2 or more records are entered, it randomly places the prod_order value. So below in category 2 should keep order of 5 and category 3 should keep order of 6.

Record 1: 124, 1, 2, 5
Record 2: 125, 1, 3, 6

Maybe there is a better way to record the product order in a table. I assume the category_assoc was the best way.

Yes the whole form that has the product name, title, description, images, and files associated gets updated. So even though I cam not changing a category, it has to reassign the associations with all the files and categories. This then gives it a new assoc_id number. But looking over it today, I can’t get it to work as done above. Because it loops dynamically with the categories check boxed selected. So when cat_id 2 and 3 are checked, it has no connection to the order. (Category -to- Order)relation doesn’t apply. I was manually adding values in the database yet the database dynamically doesn’t include the order. Thus wiping out my order column.

Basically, for every category selected for this item, create a new line. Doesn’t account for the order.