Re: delete query doesnt work

Hi, I think you are facing problem with variable delete. Make sure your Php.ini settings for global off. Check value of variable is coming on the form or not. In case of your update, i think you forget to put where part. For example: mysql_query("update table_name set varible_name='$variable_name' WHERE key_name = '$key_variable') or die(mysql_error()); May be it will help u Hardik --- Sunfire <rusty_81@msn.com> wrote: > 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 > __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com