ID: 27317
Updated by: [EMAIL PROTECTED]
Reported By: Jan at Bytesmiths dot com
-Status: Feedback
+Status: No Feedback
Bug Type: Arrays related
Operating System: MacOS X 10.3
PHP Version: 4.3.4
New Comment:
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.
Previous Comments:
------------------------------------------------------------------------
[2004-02-19 02:45:07] [EMAIL PROTECTED]
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.
------------------------------------------------------------------------
[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
