Re: Deleting a Record

cepayne@magidesign.com (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. DELETE FROM table WHERE field = 1 AND field2 = 2 -- Henrik Hansen