Hi, there's an elegant way to stop people from uploading the infos more than one time. And it's easy to do. You just have to figure out which fields are not allowed to have the same values and put those fields into an unique key. ALTER TABLE projekt ADD UNIQUE(voornaam, achternaam, email) would just allow one entry with the same names and email. The query you're searching may be like this: $query="SELECT COUNT(email) as cnt, voornaam,achternaam,leeftijd,ID,email FROM modellen GROUP BY email HAVING cnt >1"; HTH, Bastian Marco Alting schrieb: > 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
