there's an elegant way to stop people from uploading the infos more than one
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";
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
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php