Best way to prepare SQL statements?

[eluser]Sumon[/eluser]
Or this one

Code:

$this->db->from('member_info');
$Condition=array('member_status'=>'approved');
$this->db->where($Condition);
return $this->db->get();

and use this in view

Code:

if(count($Recordsets->result())==0)    echo "Sorry no member exists.";
<?php foreach($SiteFeatureInfo->result() as $row): ?>
    <?=$row->site_feature_name;?>
<?php endforeach; ?>