clear results from mysql query

[elacdude]

i have a loop that does a list of queries. but its returning the same results each way through the loop. is there a way to clear the results each time through the loop?
(i know its going through the loop right, because ive tested it by echoing them out)

for ($i=0; $i <= count($stufftodo); $i++) {
    $sql_stuff_specific = mysql_query($stufftodo[$i]);
    $chosen_stuff = mysql_fetch_row($sql_stuff_specific);


      //it displays the results here, i didnt 
      //include it because its not relavent to my question


unset($sql_stuff_specific);
unset($chosen_stuff);
}

is there an alternative to this or am i just doing it wrong?

[mcgruff]

Try a while loop:

$mysql = "SELECT ..etc...";
$query = mysql_query($mysql) or die("Cannot query the database.<br>" . mysql_error());
while($result = mysql_fetch_array($query)) {

       .......etc.......

}

[elacdude]

a while loop wont work because its a different query each time.

[mcgruff]

Sorry didn't read your post carefuly.

Not sure if this will work but try ++$i.

And, double check that the $stufftodo array really does contain all the values you are expecting.

[mcgruff]

another way to try it would be:

$i = 0;
while ($i < count($stufftodo)) {
$sql_stuff_specific = mysql_query($stufftodo[$i]);
$chosen_stuff = mysql_fetch_row($sql_stuff_specific);

...etc...

$i++;

}