Codeigniter remote connection does not return queries

[eluser]TWP Marketing[/eluser]

Code:

$mydb = $this->load->database('mydb', TRUE);
    if (!isset($mydb->conn_id) && !is_resource($mydb->conn_id)) {
        $error = 'database is not connected';
        return $error;
    }else{
        $query = $mydb->query("SELECT * FROM table_name LIMIT 1;");
        return $query->result();            
         }

The error condition returns a sting. I'm guessing that your controller doesn't check for the type of returned value and tries to process it as an object, expecting to receive $query->result().