[SOLVED] update query with multiple tables

[eluser]Dyllon[/eluser]
Maria,

You have posted several different variations of the same problem over the last few days all having to deal with undefined variables.

Now I understand that you are learning and it looks like you are trying to modify/fix an application that you did not create.
However the concept of a variable is very basic stuff and you should be able to understand what an undefined variable is and how to fix it and not run to the forum every time PHP tells you that you forgot to define a variable or that the array you are trying to use in a foreach is empty.

Asking the forum for help every time you have a minor issue is going to be an extremely slow and unproductive way to learn as people will often just feed you a solution instead of explaining the problem.

Read up on PHP and MYSQL basics, none of your issues are CI related.

When you are ready to ask a CI related question here is a good place to start http://codeigniter.com/wiki/How_to_ask_a_good_question/