Accessing database value in view

[eluser]Sumon[/eluser]
If you are using PHP 5 then the most powerful and useful one is using Method Chaining. Use this as common syntax for all of your queries in model.

Code:

$query = $this->db->select('title')
         ->from('mytable as m')
         ->join('comments as c', 'c.id = m.id');
         ->where('m.id', $id)
         ->limit(10, 20)
         ->get();
if ($query->num_rows() > 0)    
{
$row = $query->row(); //For multiple row use $query->result_array()
return $row;
}
else
{
return false;
}