Hi,
Ok i cant actully do this. I have many multiple
entries already in the table which i do not wish to
delete. And it won't alter table with these multiple
entries.
So what i need is a PHP Engineered solution, where my
PHP code would check for existing entries and deny
entry....
Thanks,
T. Edison Jr.
--- John Holmes <[EMAIL PROTECTED]> wrote:
> > 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
>
__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
