RE: [PHP] Stopping Multiple Entries in mySQL DB
| From: | John Holmes | Date: | Sat, 27 Jul 2002 16:29:00 +0000 |
| Subject: | RE: [PHP] Stopping Multiple Entries in mySQL DB | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-109983@lists.php.net to get a copy of this message | ||
> I just want my Adding Into Database script to check if
> the Name/Country already exists, and if it does, it
> shouldn't be allowed.
>
> If some with
> Name : Jackson
> Country : USA
> exists in my DB, no one with same name/country should
> be able to add his name/country in the DB.
Have your database handle that, not PHP.
When you create your table, make the combo of Name and Country unique.
CREATE TABLE your_table {
Name VARCHAR(15),
Country VARCHAR(15),
UNIQUE Name_Country (Name, Country)
}
Then you can have "Jackson, USA", "Jackson, UK", "Someone Else, USA",
etc...just not the same combination at all.
---John Holmes...