Re: delete query doesnt work

From: Date: Fri, 07 Feb 2003 22:46:11 +0000
Subject: Re: delete query doesnt work
References: 1 2 3  Groups: php.general 
Request: Send a blank email to php-general+get-134823@lists.php.net to get a copy of this message
Then you just answered your own question. -Kevin ----- Original Message ----- From: "Sunfire" <rusty_81@msn.com> To: "Kevin Stone" <kevin@helpelf.com> 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" <kevin@helpelf.com> > To: "Sunfire" <rusty_81@msn.com>; <php-general@lists.php.net> > 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" <rusty_81@msn.com> > > To: <php-general@lists.php.net> > > 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 > >

« previous php.general (#134823) next »