display query result

[eluser]li9ht[/eluser]

Code:

$sql5=$this->db->select_sum('total','total');
      $sql5=$this->db->where('date',"2008-11-22");
      $data['d22']=$this->db->get('sale',$sql5);

how do i output the result..

i've been using this code to output the result.. but the result is only 1 column result.. i dont see y i have to use foreach..but i dont know how to output a single result...

Code:

foreach($d22->result() as $d22a){
echo $d22a->total;
}

how do i output a single result.