array loop 'n' display

[knelson]

hello. the scenario:

1. A query returns item number and size information for a piece of clothing

2. Additional queries check for extended sizes of that item, such as petite and tall; extended sizes have a unique item number.

Loop:

for ( $y = 0; $y < $nrows_ext_size_desc; $y++ ) 
   {
    $init_ext_size_results[] = $ext_size_results["SZ_ALPHA"][$y]; 
   }			

Display:

			
foreach ($init_ext_size_results as $unique_ext_size_results)
   {
    echo "$unique_ext_size_results";
   }

A typical result is, however:

Extended sizes for item #1234: P0, P2, P4 (petite)

and immediately following..

Extended sizes for item #1235: P0, P2, P4, T10, T12, T14 (tall)

The last result should only display TALL sizes, but it is actually displaying the entire array results of $init_ext_size_results[].

anyone see anything obvious here? thanks for your time.

knelson

[knelson]

in other words, how do I loop through an array twice and return unique results on the second loop?

-thanks.

[Weedpacket]

Um. You could use array_filter() and keep a list of only those items you want to display the second time around. There are a whole pile of array manipulation functions; without seeing any part of your decision process I can only speculate that some combination of the functions there (with maybe the occasional loop or support function) would do the job you require.

[128kb_com]

So you are
1. looping
2. pushing $init_ext_size_results[]
3. printing

If you have these loops nested in another loop and dont reset/overwrite the old values of $init_ext_size_results[], the line:

$init_ext_size_results[] = $ext_size_results["SZ_ALPHA"][$y]

the second time around will push the other items onto the array leaving the old ones still there for the next print loop.

[knelson]

thanks for the replies. I tried yesterday to reset() the results with the following, and still got the duplicate information:

if (isset($init_ext_size_results))
			{

			reset($init_ext_size_results); 

			foreach ($init_ext_size_results as $unique_ext_size_results)

				{
					echo "$unique_ext_size_results";
				}

			}

The reset/overwrite direction is the right way to go; just have to figure out the syntax here amidst all the loops.

thanks again. knelson.

[128kb_com]

can you post more code on the specific section your having problems with?

[knelson]

here it is. there's nothing else relevant going on..

$sql_statement4_ext = OCIParse($connection,$sql4_ext)
							or die("Couldn't parse statement.");

					OCIExecute($sql_statement4_ext,OCI_DEFAULT)
						or die("Couldn't execute statement.");

					$nrows_ext_size_desc = ocifetchstatement($sql_statement4_ext, $ext_size_results);

						if ($nrows_ext_size_desc == 0)

							{
								$size_err == "There are no size matches for this item.";
							}

						else

							{ 

							$size_err == "0";

								for ( $y = 0; $y < $nrows_ext_size_desc; $y++ ) 

									{
										$init_ext_size_results[] = $ext_size_results["SZ_ALPHA"][$y]; 
									}		

if (isset($init_ext_size_results))

			{

			reset($init_ext_size_results); 

			foreach ($init_ext_size_results as $unique_ext_size_results)

				{
					echo "$unique_ext_size_results";
				}

			}

thanks again.

[knelson]

ending brace for ELSE exists in original.