[PHP] newbie database question

2004-07-13 Thread news
Hi, Thanks in advance if your able to answer this... I run a .txt perl/cgi database/shopping cart which uses the command line http://localhost/_uns/cgi-bin/store.cgi?command=listitemspos=0type=all to produce a list of all items in the database. I also have a front page index.htm which has a

[PHP] Newbie database question

2002-01-13 Thread Dean Ouellette
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 a new entry -- PHP General Mailing List

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 not

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 it is

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 enter

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 very

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 a