¥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:[EMAIL PROTECTED]
internet: http://www.suchtreffer.de
_______________________________________________________________
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
