ID: 27317
Updated by: [EMAIL PROTECTED]
Reported By: Jan at Bytesmiths dot com
-Status: Open
+Status: Feedback
Bug Type: Arrays related
Operating System: MacOS X 10.3
PHP Version: 4.3.4
New Comment:
Please provide a short reproducing script that does not require any
database or precondiftions like the page generating your queries or
provide your query string and the way it is parsed to the variables -
but only if that is really neccessary.
Previous Comments:
------------------------------------------------------------------------
[2004-02-19 02:28:45] Jan at Bytesmiths dot com
Description:
------------
array_unique seems to be losing a value somehow when two
arrays are merged that contain the same value. I am
merging two arrays, then feeding the result to
array_unique. (What I REALLY want is a set!) print_r
seems to show a proper result. However, waling through
the array results in an empty value. In this
case, 'IsNew' is missing. I changed the order of the
merge, and a DIFFERENT value was missing!
If merging the two arrays results in a set (no
duplicates), then array_unique seems to work fine.
Reproduce code:
---------------
// $InfoThumb AND $PopupThumb determine what fields to fetch. Build the
proper query string.
$fieldNames = array_unique(array_merge($PopupThumb, $InfoThumb));
print_r($PopupThumb);
print_r($InfoThumb);
print_r($fieldNames);
for($i=0; $i<count($fieldNames); $i++)
$fields .= ', ' . $fieldNames[$i];
$inc = $NumberOfColumns * $NumberOfRows;
$sql = "SELECT ID, ImageThumb, ToShow $fields FROM Gallery" .
$sql_filter . $sql_sort;
if($total >= $inc) $sql .= " LIMIT $start, $inc";
die($sql);
Expected result:
----------------
SELECT ID, ImageThumb, ToShow ,
Title, Price, IsNew, Medium, Width, Height, Depth FROM
Gallery WHERE ToShow=1 ORDER BY Updated DESC LIMIT 0, 10
Actual result:
--------------
Array ( [0] => Title [1] => Price ) Array ( [0] =>
Title [1] => Medium [2] => Width [3] => Height [4]
=> Depth [5] => IsNew ) Array ( [0] => Title [1] =>
Price [3] => Medium [4] => Width [5] => Height [6]
=> Depth [7] => IsNew ) SELECT ID, ImageThumb, ToShow ,
Title, Price, , Medium, Width, Height, Depth FROM
Gallery WHERE ToShow=1 ORDER BY Updated DESC LIMIT 0, 10
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=27317&edit=1
