#42961 [NEW]: mysqli would not return result values within "for" loop.

From: wilsonwg at gmail dot com Operating system: Windows XP SP2 PHP version: 5.2.4 PHP Bug Type: MySQLi related Bug description: mysqli would not return result values within "for" loop. Description: ------------ I set up an array in the code and then use the for loop to query my database. However, the mysqli functions would not return the result values. This is the table used for the query(columns separated a comma): ------------- id, item_name ------------- 1, item_1 2, item_2 3, item_3 4, item_4 ------------- Reproduce code: --------------- $mysqli_connect =mysqli_connect("localhost", "root", "password", "myDB"); $array_items = "item_1,item_2,item_3,item_4"; $array_list = explode (",", $array_items); for ($i=0; $i<count($array_list); $i++){ $select_item = "SELECT * FROM compounds where item_name = '".$array_list[$i]."'"; echo "$select_item <p>"; $search_item_query = mysqli_query($mysqli_connect, $select_item); $result = mysqli_fetch_array($search_item_query); $id = $result['item_id']; echo "$id <p>"; } Expected result: ---------------- SELECT * FROM compounds where compound_name = 'item 1' 1 SELECT * FROM compounds where compound_name = 'item 2' 2 SELECT * FROM compounds where compound_name = 'item 3' 3 SELECT * FROM compounds where compound_name = 'item 4' 4 Actual result: -------------- SELECT * FROM compounds where compound_name = 'item 1' SELECT * FROM compounds where compound_name = 'item 2' SELECT * FROM compounds where compound_name = 'item 3' SELECT * FROM compounds where compound_name = 'item 4' -- Edit bug report at http://bugs.php.net/?id=42961&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=42961&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=42961&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=42961&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=42961&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=42961&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=42961&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=42961&r=needscript Try newer version: http://bugs.php.net/fix.php?id=42961&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=42961&r=support Expected behavior: http://bugs.php.net/fix.php?id=42961&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=42961&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=42961&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=42961&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=42961&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=42961&r=dst IIS Stability: http://bugs.php.net/fix.php?id=42961&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=42961&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=42961&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=42961&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=42961&r=mysqlcfg