Thanks I have now five ways to try. ---------------------------- | Chuck Payne | | Magi Design and Support | | [EMAIL PROTECTED] | ----------------------------
-----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: >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 | > | [EMAIL PROTECTED] | > ---------------------------- > >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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php