#31385 [NEW]: Extract - problem

From: boriskolev at abv dot bg Operating system: RedHat 9.1 PHP version: 4.3.8 PHP Bug Type: Arrays related Bug description: Extract - problem Description: ------------ When you have array with text index-es(hash) and when you extract this array to variables if some of array columns have null value variable for this column do not clears. For example in code reproduce : if for example column "keyword" is null for some row variable $keyword after extracting do not clears. Reproduce code: --------------- $query = "SELECT a.agent_sid, a.country_sid, a.region_sid, a.keyword, a.agent_frequency_sid, a.last_email, u.email, CONCAT(u.first_name, ' ', u.last_name) as fullname FROM AGENT a INNER JOIN USER u ON a.user_sid=u.user_sid INNER JOIN OBJECT_HISTORY o ON u.object_history_sid=o.object_history_sid WHERE o.object_status_sid=1 AND (a.agent_frequency_sid=2 OR agent_frequency_sid=DAYOFWEEK(DATE_ADD(CURDATE(), INTERVAL -1 DAY))+2) "; $agent_result = query($query);while ($row = mysql_fetch_array($agent_result,MYSQL_ASSOC)) { extract($row); }; Expected result: ---------------- to fech result into array and then to extract array into variables for each row and if cell empty or null variable be empty too. Actual result: -------------- variable do not clears -- Edit bug report at http://bugs.php.net/?id=31385&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=31385&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=31385&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=31385&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=31385&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=31385&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=31385&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=31385&r=needscript Try newer version: http://bugs.php.net/fix.php?id=31385&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=31385&r=support Expected behavior: http://bugs.php.net/fix.php?id=31385&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=31385&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=31385&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=31385&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=31385&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=31385&r=dst IIS Stability: http://bugs.php.net/fix.php?id=31385&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=31385&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=31385&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=31385&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=31385&r=mysqlcfg