[SOLVED]database error occurred

[eluser]kikz4life[/eluser]
this is the output that i got when insert this code die('<pre>'.print_r($query,TRUE).'</pre>');:

Code:

CI_DB_mysql_result Object
(
    [conn_id] => Resource id #35
    [result_id] => Resource id #103
    [result_array] => Array
        (
        )

    [result_object] => Array
        (
        )

    [current_row] => 0
    [num_rows] => 2
    [row_data] =>
)

Controller

Code:

function index()
    {
        ........
        $data['order_type'] = $this->Dataset_db->getTypes('CUST_TYPE');
    $data['internal_terms'] = $this->Dataset_db->getTypes('TERMS');
    $data['customer_terms'] = $this->Dataset_db->getTypes('TERMS');
    $data['operator'] =$this->Dataset_db->getSearchTypes('OPERATOR');        
    $data['content'] = $this->load->view('home',$data,true);
    $this->load->vars($data);
    $this->load->view('default_view');
    }
        }

i'm using the flexigrid jquery for the view.

modifying and using the two where clause this is the error the i get(firebug):
POST http://localhost/myweb/ar_salesorder/listview
500 Internal Server Error
979ms