Need Help Wih SELECT SUM()

[eluser]Jay Logan[/eluser]
OK, I can get it to work with some good, old fashion PHP.

Code:

function get_team_points($id, $teamname){
        $sql = mysql_query("SELECT SUM(teampoints) AS points FROM ievents WHERE meet_id = '207' AND teamname = 'Ben Lippen HS'");
        $row = mysql_fetch_assoc($sql);
        return $row['points'];
    }

The problem with this is that I can't pass the variables $id and $teamname from the controller. Is there a CI version of the above code?