How to return single result from database

[eluser]Thorpe Obazee[/eluser]

Code:

// model
function get_dollars_by_month ($month, $donator_co)
    {
        $query = $this->db->query("SELECT SUM( dollars )
        AS thesum FROM fh_financial_donations
        WHERE MONTH( date ) = MONTH( DATE_SUB( CURDATE( ) , INTERVAL ".$month."
        MONTH ) ) AND donator_co = ".$donator_co."");
        return ($query->num_rows()) ? $query->row() : FALSE
    }

//Controller

$data = $this->yourmodel->get_dollars_by_month($month, $donator_co);

echo $data->thesum;

or you can do this:

Code:

// model
function get_dollars_by_month ($month, $donator_co)
    {
        $query = $this->db->query("SELECT SUM( dollars )
        AS thesum FROM fh_financial_donations
        WHERE MONTH( date ) = MONTH( DATE_SUB( CURDATE( ) , INTERVAL ".$month."
        MONTH ) ) AND donator_co = ".$donator_co."");
        return ($query->num_rows()) ? $query->row()->thesum : FALSE
    }

//Controller

$thesum = $this->yourmodel->get_dollars_by_month($month, $donator_co);

echo $thesum;