unset() unsanity

[knelson]

hello.

is there some other way to vaporize an array, apart from the following?

unset($array);
unset($GLOBALS['array']);
$array = NULL;

Because none of these are working for me. The array in question is part of a DB query nested loop that must be overwritten so that I don't display duplicate entries.

while ($it_row = mysql_fetch_array($it_select_result))
{
unset($new_results);

--use MySQL results to query another DB, to return the $new_results array--

 foreach ($new_results as $final_results)
  {
  echo "$final_results";
  }
}

A typical result set might be:
item 1, value 1
item 2, value 1, 2
item 3, value 1,2,3

when it should be:
item 1, value 1
item 2, value 2
item 3, value 3

any help is GREATLY appreciated.

thanks folks. knelson.

[devinemke]

where is $new_results getting set? if it is inside the while loop then it will still be set even after the while loop is over (because you are unsetting it at the beginning of the loop).

[knelson]

the "$new_results" array is returned inside my first loop:

1. MySQL query
2. loop through results (a series of item numbers), and then query an Oracle DB with each number to get the $new_results array
3. iterate over the $new results array using foreach to display the related info for each item number.

That's why I'm trying to erase the $new_results array at the beginning of #2, before Oracle is queried again. Is that clear? (I don't know anymore!) I'm hesitant to post all the code, because it's long, but I'm happy to do so. thanks

[knelson]

sorry, I'll try to clarify more.

1. MySQL query
2. Take MySQL results (item numbers) and query Oracle with each number in a WHILE loop.
3. If related item numbers exist, create an array that contains them, iterate over the array using FOREACH, and perform another query on the Oracle DB for info about these related items.
4. Display the related items, and all their information, underneath the primary item.

Here's the monster, greatly trimmed down:

					while ($it_row = mysql_fetch_array($it_select_result))

{

unset($also_results);

/*QUERY ORACLE BY PRIMARY NUMBER FOR  INFO AND RELATED ITEM NUMBERS*/
include("oracle_see_also_connect.inc");

echo "INFO ABOUT PRIMARY NUMBER";	

/*$also_results IS THE ARRAY OF RELATED NUMBERS RETURNED BY ORACLE QUERY ABOVE*/							
if ($also_results)

{

foreach ($also_results as $final_see_also_result)

{

/* QUERY ORACLE USING NUMBERS FROM THE $also_results ARRAY */

echo "ALL THE INFORMATION ABOUT THE RELATED NUMBERS";

}								
}
}