Then you just answered your own question. -Kevin ----- Original Message ----- From: "Sunfire" <[EMAIL PROTECTED]> To: "Kevin Stone" <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 3:37 PM Subject: Re: [PHP] delete query doesnt work
> ok so i mistyped it the real one is > mysql_query("delete from members where company='$delete'"); > > and checking errors doesnt work because for some reason the $delete is empty > > > ----- Original Message ----- > From: "Kevin Stone" <[EMAIL PROTECTED]> > To: "Sunfire" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, February 07, 2003 5:05 PM > Subject: Re: [PHP] delete query doesnt work > > > > You have a syntax error. Look at your quotes. > > -Kevin > > > > ----- Original Message ----- > > From: "Sunfire" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Friday, February 07, 2003 3:05 PM > > 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 > > > > > > > --- > 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