RE: Deleting a Record

Thanks I have now five ways to try. ---------------------------- | Chuck Payne | | Magi Design and Support | | cepayne@magidesign.com | ---------------------------- -----Original Message----- From: Paul DuBois [mailto:paul@snake.net] Sent: Wednesday, March 06, 2002 10:43 AM To: Chuck "PUP" Payne; mysql@lists.mysql.com 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 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@magidesign.com | > ---------------------------- > >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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <mysql-thread102093@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-cepayne=magidesign.com@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php