Ok I see, and how would you catch the error people get, when they send it
"Bastian Vogt" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> there's an elegant way to stop people from uploading the infos more than
> And it's easy to do. You just have to figure out which fields are not
> 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
> modellen GROUP BY email HAVING cnt >1";
> Marco Alting schrieb:
> > I have a database which allows people to upload info and foto's. There's
> > unique ID field, but some people tend to upload their info more than
> > (its a contest site). What I'm able to do is to see how may duplicates
> > are using the following statement:
> > $query="SELECT COUNT(*) as cnt, voornaam,achternaam,leeftijd,ID,email
> > modellen GROUP BY email HAVING cnt >1";
> > But this only gives me numbers. Does anyone know how to display every
> > that has multiple duplicate ?
> > Or is there an elegant way to stop people from entering their info more
> > once?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php