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:
Advertising
$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
