> 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...

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to