Re: reset a resource?

From:	Brad Bonkoski	Date:	Thu, 08 Jun 2006 18:39:14 +0000
Subject:	Re: reset a resource?
References:	1	Groups:	php.general
Request:	Send a blank email to php-general+get-237645@lists.php.net to get a copy of this message

Perhaps this will help: http://www.php.net/manual/en/function.mysql-data-seek.php -brad sam wrote:

After I've looped through a resource do I have to run the query again to load up 'mysql_fetch_assoc' or is there some kind of reset function I can't find? $q = "SELECT * FROM table; $s = mysql_query($q, $pe) or die(mysql_error()); while ($row_s = mysql_fetch_assoc($s)) {
    echo $i++;
} outputs "12345..." for each row of table while ($row_s2 = mysql_fetch_assoc($q)) {
    ...
} and $q is your query, I'm surprised this does not throw an error, unless you snipped some other code out of there...

outputs "" Thanks