Active records for beginners...

[eluser]cahva[/eluser]
You can safely shorten your model method to this:

Code:

function getmy ($id)
{
    return $this->db->get_where('socialhubspot', array('company_id' => $id))->row();
}

row() method always returns only one row so you dont have to use "$q->row(0)".

now in the controller:

Code:

$data['row']=$this->backend->getmy($my_id);
$this->load->view('frontend',$data);

In view:

Code:

<?php echo $row->somefield ?>