[SOLVED] update query with multiple tables

[eluser]flaky[/eluser]

Code:

switch($postConfig['action']){
            
            case $crudConfig['update']:
                $updateArray = array();
                /*$this->db->where('si_id', $this->input->post('id'));
                $this->db->update($crudTableName);*/
                $sql = 'update '.$crudTableName.' set ';
                //foreach($crudColumns as $key => $value){ $updateArray[$key] = $value.'='.$crudColumnValues[$key]; };
                foreach($crudTableName as $key => $value){ $updateArray[$key] = $value.'='.$crudColumnValues[$key]; };
                $sql .= implode(',',$updateArray);
                $sql .= ' where role_id = '.$crudColumnValues['id'];
                mysql_query( $sql );
                break;
                    }