> I know the SELECT DISTINCT function. But I need to delete duplications
> the finished resultset. Is that in any way possible? The result-set is
> like an usual array, is it? I've tried the unique_array function, but
> didn't work.
You have to add the result set into an array, first.
Loop through your result and add each element into an array. Then you
should be able to use array_unique on the resulting array.
It's a huge waste of time, though, just do it in your query. If you need
both result sets, then just issue two queries. Benchmark, though, to
make sure whatever you're using is the fastest.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php