[eluser]Blue Sapphire[/eluser]
Hi!
I have following code of custom made helper function:
Code:
function mCountry(){
$query = $this->db->query('select * from fa_country');
if($query->num_rows() >0)
{
$nbrows = $query->num_rows();
foreach($query->result() as $res){
$rec['id'] = $res->id;
$rec['iso'] = $res->iso;
$rec['name'] = $res->name;
$rec['iso3'] = $res->iso3;
$rec['numcode'] = $res->numcode;
$arr[] = $rec;
}
$jsonresult = JEncode($arr);
echo '({"total":"'.$nbrows.'","results":'.$jsonresult.'})';
//echo '({"total":"'.$nbrows.'","results":'.$jsonresult.'})';
}
In above mentioned code, how can I call, DB laibrary of CI. Because with current syntax, it is giving me error of "Call to a member function on a non-object............." .
Can anyone guide me in this regards.
Thanks in advance