Re: delete query doesnt work

it doesnt say anything query returns 1 and there are 0 errors and 0 warnings but when i echo the query string: echo "delete from members where company= '$delete'"; it will show on the web page: delete from members where company = so the $delete is blank for some reason... is it possible that submitting a variable from 1 form to another that some wont get carried over? ----- Original Message ----- From: "Van Andel, Robbert" <RVanAndel@chartercom.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 What is the error message you get if you put this in if(!mysql_query("delete from members where company='$delete')) die (mysql_error()); This would be the first step. Robbert van Andel -----Original Message----- From: Sunfire [mailto:rusty_81@msn.com] Sent: Friday, February 07, 2003 2:06 PM To: php-general@lists.php.net 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