Oracle Query; Trim dupes from Array

[knelson]

Hello-

Here is the array ($color_results) returned in a simple way:

$nrows_color_desc = ocifetchstatement($sql_statement3, $color_results);

	for ( $i = 0; $i < $nrows_color_desc; $i++ ) 

		{	
		    	$color_results["result_one"][$i];
		   	$color_results["result_two"][$i];
		    	$color_results["result_three"][$i];
	    		$color_results["result_four"][$i];
}

Problem: With this method, I get tons of duplicate records in my display and need to remove them. I have tried to create another array with array_unique:

$new_array = array_unique($color_results);

-but I can't get any results to display at all.

thanks for your help.

[gwchamb]

Problem: With this method, I get tons of duplicate records in my display and need to remove them. I have tried to create another array with array_unique:

Have you investigated the DISTINCT keyword in your SELECT statement?

-- Gary