note 9899 added to mysql_fetch_array
| From: | arlo at typea dot net | Date: | Thu, 30 Nov 2000 06:47:51 +0000 |
| Subject: | note 9899 added to mysql_fetch_array | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-8290@lists.php.net to get a copy of this message | ||
The behavior Sasha describes becomes problematic if your mysql_fetch_array() is followed by
extract() in a loop that writes out results from a query. If a field value is null, then extract()
won't recreate the corresponding variable, and the variable will remain set to the value from
the previous row. This gave some unexpected results until I figured out what was going on.
I'll post a workaround here if I can figure out a good one.
Arlo Leach
www.typea.net
http://www.php.net/manual/function.mysql-fetch-array.php