RE: [PHP-WIN] Need someone with some experience
| From: | Michael Rudel | Date: | Thu, 10 May 2001 08:29:11 +0000 |
| Subject: | RE: [PHP-WIN] Need someone with some experience | ||
| References: | 1 | Groups: | php.windows |
| Request: | Send a blank email to php-windows+get-7437@lists.php.net to get a copy of this message | ||
¥es, try this statement:
select [field_with_duplicate_entries], count(*) as num_entries from [yourDB] group by
[field_with_duplicate_entries] having
num_entries > 1;
So you get all duplicates. Store them in a array.
Make your 500-records-select and check the [field_with_duplicate_entries] with in_array -->
highlight it or not.
Just my 0.02 Euro.
Greetinx,
Mike
Michael Rudel
- Web-Development, Systemadministration -
_______________________________________________________________
Suchtreffer AG
Bleicherstraße 20
D-78467 Konstanz
Germany
fon: +49-(0)7531-89207-17
fax: +49-(0)7531-89207-13
e-mail: mailto:mru@suchtreffer.de
internet: http://www.suchtreffer.de
_______________________________________________________________