Running Update Query

[Brandin]

Hey!

I am using the UserSpice pages in many ways, and one of them is a migration tool. Basically, I have a list of categories, and if I migrate the category number to be another number, I also want to update all of the templates with that category number, to the new one. Currently, I am using the default function from the

Code:

admin_user.php

page that I just modified to my good, and I have this:

<pre>

Code:

//Update catnum

    if ($number != $_POST['number']){
       $number = Input::get("number");

      $fields=array('number'=>$number);
      $validation->check($_POST,array(
        'number' => array(
          'display' => 'Number',
          'required' => true,
          'min' => 1,
          'max' => 3
        )
      ));
    if($validation->passed()){
      $db->update('categories',$id,$fields);
      $successes[] = "Sort Updated";

</pre>


But what I need to do is also update the

Code:

templates

table

Code:

WHERE category=

the new

Code:

$number

I have set.

If you could help with the

Code:

$db->

function for this, I would be VERY appreciative

Thanks again!