List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 6 2002 3:42pm
Subject:Re: Deleting a Record
View as plain text  
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 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 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  |
>  | cepayne@stripped   |
>  ----------------------------
>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 Fierstein
Deleting a RecordChuck \"PUP\" Payne6 Mar
  • RE: Deleting a RecordRoger Baklund6 Mar
  • Re: Deleting a RecordPaul DuBois6 Mar
    • RE: Deleting a RecordChuck \"PUP\" Payne6 Mar