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:[EMAIL PROTECTED]]
Sent: Friday, February 07, 2003 2:06 PM
To: [EMAIL PROTECTED]
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

Reply via email to