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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
