displaying duplicate records...
| From: | Marco Alting | Date: | Wed, 04 Dec 2002 10:47:07 +0000 |
| Subject: | displaying duplicate records... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23790@lists.php.net to get a copy of this message | ||
I have a database which allows people to upload info and foto's. There's a
unique ID field, but some people tend to upload their info more than once
(its a contest site). What I'm able to do is to see how may duplicates there
are using the following statement:
$query="SELECT COUNT(*) as cnt, voornaam,achternaam,leeftijd,ID,email FROM
modellen GROUP BY email HAVING cnt >1";
But this only gives me numbers. Does anyone know how to display every record
that has multiple duplicate ?
Or is there an elegant way to stop people from entering their info more than
once?