First two things I'd check: (1) Make sure the user you're connecting as has permission to delete rows, and (2) Make sure that your $delete variable has the value you were expecting.
--- Mark Roedel | "Blessed is he who has learned to laugh Systems Programmer | at himself, for he shall never cease LeTourneau University | to be entertained." Longview, Texas, USA | -- John Powell > -----Original Message----- > From: Sunfire [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 07, 2003 4:06 PM > To: [EMAIL PROTECTED] > Subject: [PHP] delete query doesnt work > > > i have a delete query: > mysql_query("delete from members where company='$delete'); > > it doesnt work should i change it to : > mysql_query("delete from members where company like '$delete'");?? > > the first one worked in mysql client but it doesnt work in > php script for > some reason... > > > also having problems with update... if nothing on the form > changes and it > gets submitted anyways all the records in the db gets changed > to the same > thing that one record has in it... > > > > > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003 > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php