> 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
