RE: [PHP] delete query doesnt work

Maybe you have to use wildcards like: mysql_query("delete from members where company like '%$delete%'");?? Daniel E Massón. Ingeniero de desarrollo dmasson@imagine.com.co ____________________________________ Imagine S.A. Su Aliado Efectivo en Internet www.imagine.com.co (57 1)2182064 - (57 1)6163218 Bogotá - Colombia ____________________________________ - Soluciones web para Internet e Intranet - Soluciones para redes - Licenciamiento de Software - Asesoría y Soporte Técnico ____________________________________ -----Mensaje original----- De: Sunfire [mailto:rusty_81@msn.com] Enviado el: viernes, 07 de febrero de 2003 17:06 Para: php-general@lists.php.net Asunto: [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