First two things I'd check:

(1) Make sure the user you're connecting as has permission to delete
rows, and
(2) Make sure that your $delete variable has the value you were
expecting.


---
Mark Roedel           | "Blessed is he who has learned to laugh
Systems Programmer    |  at himself, for he shall never cease
LeTourneau University |  to be entertained."
Longview, Texas, USA  |                          -- John Powell


> -----Original Message-----
> From: Sunfire [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, February 07, 2003 4: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