Best way to prepare SQL statements?

[eluser]Sumon[/eluser]
This reduce only else(if...else) block. i.e parenthesis. However, it doesn't display error for empty recordset. Anyway, thanks.
Finally one more way of view:

Code:

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