Re: [PHP] Newbie database question

2002-01-13 Thread Peter J. Schoenster
On 13 Jan 2002, at 12:51, Dean Ouellette wrote: > I am entering info from form into database, is there a way to check > say firstname, lastname and address to see if it is a duplicate to > what is already in database and if it is then just enter any new > information they may enter and not create

Re: [PHP] Newbie database question

2002-01-13 Thread Richard Crawford
I don't think that there's an easy way to do it in MySQL. I usually use some hack along the lines of, "select x from t where x = $y", and if there are any results returned, return a message of some sort ("That value already exists in the database!"). Bear in mind that sometimes people have ve

Re: [PHP] Newbie database question

2002-01-13 Thread mike cullerton
on 1/13/02 10:51 AM, Dean Ouellette at [EMAIL PROTECTED] wrote: > I am entering info from form into database, is there a way to check say > firstname, lastname and address to see if it is a duplicate to what is > already in database and if it is then just enter any new information they > may ente

Re: [PHP] Newbie database question

2002-01-13 Thread Dean Ouellette
MySql At 10:10 AM 1/13/2002 -0800, Richard Crawford wrote: >Which database are you using? > > >Dean Ouellette wrote: > >>I am entering info from form into database, is there a way to check say >>firstname, lastname and address to see if it is a duplicate to what is >>already in database and if

Re: [PHP] Newbie database question

2002-01-13 Thread Richard Crawford
Which database are you using? Dean Ouellette wrote: > I am entering info from form into database, is there a way to check say > firstname, lastname and address to see if it is a duplicate to what is > already in database and if it is then just enter any new information > they may enter and n