Thanks I have now five ways to try.

 | Chuck Payne              |
 | Magi Design and Support  |

-----Original Message-----
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 06, 2002 10:43 AM
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:
>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
>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 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.

Connect the conditions with AND:

DELETE FROM tbl_name WHERE col1 = 'value1' AND col2 = 'value2'

>  ----------------------------
>  | Chuck Payne              |
>  | Magi Design and Support  |
>  ----------------------------
>BeOS, Macintosh 68K, Classic, and OS X, Linux Support.
>Web Design you can afford.
>"Never be bullied into silence. Never allow yourself to be made a victim.
>Accept no one's definition of your life; define yourself."- Harvey

Before posting, please check:   (the manual)           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
Trouble unsubscribing? Try:

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to