> 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....
So do it...
SELECT 1 FROM your_table WHERE name = 'NAME FROM FORM' AND city = 'CITY FROM
FORM'
If a row is returned, then a match is found and you shouldn't insert it
again. If no row is returned, then there's no match and you can insert.
You'd be better off to clean up your database now, though...
---John Holmes...
> --- 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
