RE: Deleting a Record

2002-03-06 Thread Chuck \"PUP\" Payne
To: Chuck "PUP" Payne; [EMAIL PROTECTED] Cc: PHP General Subject: Re: Deleting a Record At 7:46 -0500 3/6/02, Chuck \"PUP\" Payne wrote: >Hi, > >I a seting up a php page that will let me delete a record from my mysql >database, but I want it be able to match to

Re: Deleting a Record

2002-03-06 Thread Paul DuBois
At 7:46 -0500 3/6/02, Chuck \"PUP\" Payne wrote: >Hi, > >I a seting up a php page that will let me delete a record from my mysql >database, but I want it be able to match to fields before it will let a user >delete that record. I know the basic sql command is > >DELETE FROM $table WHERE field

RE: Deleting a Record

2002-03-06 Thread Roger Baklund
* Chuck "PUP" Payne > I know the basic sql command is > > DELETE FROM $table WHERE field 1 = "$value" > > But I don't know how to write the state for a second field. Can some one > tell, but one field seem to give too much choose and would make it to easy > to delete the wrong record. I think

Deleting a Record

2002-03-06 Thread Chuck \"PUP\" Payne
Hi, I a seting up a php page that will let me delete a record from my mysql database, but I want it be able to match to fields before it will let a user delete that record. I know the basic sql command is DELETE FROM $table WHERE field 1 = "$value" But I don't know how to write the state fo

Re: Deleting a record

2002-02-22 Thread Michael Stassen
On Sat, 23 Feb 2002, Jon Shorie wrote: > I am working on a perl application that manages a database created in Mysql. > I am having trouble with the delete statement. Here is a portion of the > perl code > that is being executed: > > $dbh=DBI->connect("dbi:mysql:clientdb:localhost","web","web

Re: re: deleting a record

2002-02-22 Thread Jon Shorie
At 06:18 AM 2/23/2002 +0100, you wrote: >Your message cannot be posted because it appears to be either spam or >simply off topic to our filter. To bypass the filter you must include >one of the following words in your message: > >sql,query > >If you just reply to this message, and include the enti

Deleting a record

2002-02-22 Thread Jon Shorie
I am working on a perl application that manages a database created in Mysql. I am having trouble with the delete statement. Here is a portion of the perl code that is being executed: $dbh=DBI->connect("dbi:mysql:clientdb:localhost","web","webpassword"); ### # Delete Routine