[PHP-DB] Re: displaying duplicate records...

2002-12-04 Thread Bastian Vogt
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

[PHP-DB] Re: displaying duplicate records...

2002-12-04 Thread Marco Alting
Ok I see, and how would you catch the error people get, when they send it again ? Bastian Vogt [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... 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

[PHP-DB] Re: displaying duplicate records...

2002-12-04 Thread Bastian Vogt
Marco Alting schrieb: Ok I see, and how would you catch the error people get, when they send it again ? Well, there will be no error-message... if you use mysql (do you?) ;-) If you want a message you will have to select all rows from your table where the values the user wants to insert are