DB Update with multiple inputs in a loop

[eluser]Ludovic-r[/eluser]
Thanks for your time so much!

Let me provide you more informations :

The DB :

Code:

TABLE 1 called 'ft_categories' with 2 fields : 'id', 'category_name'
TABLE 2 called 'ft_upload_data' with 2 fields : 'id', 'category'

I just need to update my fields (from the form) in the TABLE 1 in the field called 'category_name' AND in the TABLE 2 in the field called 'category'

I can't reach this goal with your code, it works perfectly but with the '$this->db->set('dat.category_name', 'cat.category_name');' the field 'category' in the TABLE 2 won't update with the right data.

Any ideas?

I'm sorry to waste your time