[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=listitems&pos=0&type=all to produce a list of all items in the database. I also have a front page index.htm which has a h

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

[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 (http://w