Having Trouble Linking Values of 2 Functions

[eluser]Jay Logan[/eluser]
Not returning the expected result. I've been messing with some MySQL in phpMyAdmin to see what statement works and came up with this:

Code:

SELECT SUM(teampoints) FROM (SELECT teampoints from ievents WHERE meet_id = ? AND teamname = ? AND eventgender = 'F' AND teampoints != 0 ORDER BY teampoints LIMIT 5)

This returns the correct result. Now, to try it work in CI is another story.