Class/MySQL Return one result at a time

[Wynder]

Greetings again.

I'm writing a custom class to handle MySQL functions and what I'm attempting to do is write a class function that will return one result at a time, ie:

$result = MySQL->nextResult();
$result = MySQL->nextResult();

I know I can use the MYSQL_ASSOC constant in the fetch array to have the columns indexed by their fieldname, but I'm wondering if anyone would have any thoughts or suggestions on the best logic to use in this process.