Re: code problem
| From: | John Holmes | Date: | Sun, 31 Oct 2004 21:29:04 +0000 |
| Subject: | Re: code problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-200782@lists.php.net to get a copy of this message | ||
Ross Hulford wrote:
This is my code........................... [snip]
mysql_free_result($Recordset1); ...
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?> It displays one result then thows up the following error Warning: mysql_fetch_assoc(): 3 is not a valid MySQL result resource in c:\inetpub\wwwroot\testy\Untitled-1.php on line 29You free the result and then try to fetch more rows from it... not going to work. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com