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?



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to