include('include/common.php'); include('include/util.php'); include('include/bucket.php'); $aItem = getBucket(); $matchStr = ""; $aItemNum = array(); $aItemName = array(); /* Find out all items and item number and name */ for ( $i = 0 ; $i < count($aItem) ; $i++ ) { $curItemNum = $aItem[$i]; if ( $matchStr == "" ) $matchStr = "Id=$curItemNum"; else $matchStr = $matchStr . " OR Id=$curItemNum"; } $itemNumNameList = ""; if ( count($aItem) > 0 ) { $sql = "SELECT * from Product WHERE $matchStr"; if ($result = $db->sql_query($sql)) { $numRow = $db->sql_numrows($result); for ( $i = 0 ; $i < $numRow ; $i++ ) { $row = $db->sql_fetchrow($result); $aItemNum[$i] = $row['ProductNum']; $aItemName_Eng[$i] = $row['Name_Eng']; $aItemName_Chi[$i] = $row['Name_Chi']; $itemNumNameList = $itemNumNameList . $aItemNum[$i] . ": " . $aItemName_Eng[$i] . "-" . $aItemName_Chi[$i] . ";\n"; } } $db->sql_freeresult($result); } ?>