Proper way to return sql results

[eluser]WanWizard[/eluser]
The query runs only once, that's not a problem.

It does uses some memory and processing as you fetch the resultset twice. You can do

Code:

if ( $query->num_rows() )
{
    return $query->result_array()
}
else
{
    return FALSE;
}