if (mysql_num_rows($query)){
    mysql_data_seek($query, 0);
}

$result = mysql_query($query);
if (!$result) {
    echo 'Could not run query: ' . mysql_error();
    exit;
}
while($row = mysql_fetch_row($result)){
    $myResultSet[]=$row;
}

foreach($myResultSet as $row){  # note foreach resets each time
    # do stuff with $row['fieldname']
}