How do I re-use query results?

[eluser]Dam1an[/eluser]
I thought you need the & to do it by reference? (at least thats the case with get_instance())

And I just checked, the function to reset the internal pointer is

Code:

mysql_data_seek($query, 0);

Where $query is the result of mysql_result_assoc, not the CI result, so you'll need to modify the Db class to add that functionality (maybe it could be a feature request for the next version?)