desperate for array help

[knelson]

hello-

I am returning results from an Oracle DB using a while loop:

while(OCIFetch($sql_statement3))

		{

		 	$a = OCIResult($sql_statement3, "col_name1");
			 $b = OCIResult($sql_statement3, "col_name2");
			$c = OCIResult($sql_statement3, "col_name3");
			 $d = OCIResult($sql_statement3, "col_name4");

		}

Simple. But due to the nature of the DB (over which I have no control), I get TONS of duplicate results that I need to trim.

1. How do I put these results from a loop into an array? (I am going on the assumption that I can later trim my duplicates from that array with array_unique().)

thank you very, very much.

knelson

[[deleted]]

while(OCIFetch($sql_statement3))

{

$a[] = OCIResult($sql_statement3, "col_name1");
$b[] = OCIResult($sql_statement3, "col_name2");
$c[] = OCIResult($sql_statement3, "col_name3");
$d[] = OCIResult($sql_statement3, "col_name4");

}

Simple as that..in an array....

And yes, array_unique should handle the duplicates for you....

Another option is to use grouping functionality of sql to eliminate duplicates.....

[knelson]

your tip saved the day.