Re: [PHP] delete query doesnt work (fixed)

2003-02-07 Thread Chris Shiflett
--- Sunfire <[EMAIL PROTECTED]> wrote: > in the form that submits the $delete var add this: > > now in query change $delete to $flag_delete... and poof > it magically works It's not magic, and John Holmes already explained it to you. If you do not pass a variable via GET, POST, or as a cookie, a

Re: [PHP] delete query doesnt work

2003-02-07 Thread Hardik Doshi
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_na

Re: [PHP] delete query doesnt work

2003-02-07 Thread Sunfire
the checkbox to the query string it gets lost... - Original Message - From: "Van Andel, Robbert" <[EMAIL PROTECTED]> To: "Sunfire" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 6:14 PM Subject: RE: [PHP] delete query doesnt w

RE: [PHP] delete query doesnt work

2003-02-07 Thread Van Andel, Robbert
: Friday, February 07, 2003 3:16 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] delete query doesnt work ok i changed the endings to those to but still keep getting blank variable in the end for $delete in the delete query - Original Message - From: "Van Andel, Robbert" <[EMAIL P

RE: [PHP] delete query doesnt work

2003-02-07 Thread John W. Holmes
e [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 07, 2003 6:16 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP] delete query doesnt work > > ok i changed the endings to those to but still keep getting > blank > variable in the end for $delete in the delete query > >

Re: [PHP] delete query doesnt work

2003-02-07 Thread Kevin Stone
t; > To: "Sunfire" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, February 07, 2003 5:51 PM > Subject: RE: [PHP] delete query doesnt work > > > You're form code is incorrect. > > select a member to delete > > should read > &

Re: [PHP] delete query doesnt work

2003-02-07 Thread Sunfire
ent: Friday, February 07, 2003 5:51 PM Subject: RE: [PHP] delete query doesnt work You're form code is incorrect. select a member to delete should read select a member to delete The line: value=\"$DeleteMember[Company]\">\"$DeleteMember[Company]\""; should read val

RE: [PHP] delete query doesnt work

2003-02-07 Thread Van Andel, Robbert
ny]\""; Robbert van Andel -Original Message- From: Sunfire [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 2:56 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] delete query doesnt work here is the forms that delete uses: //the first one is the combo box to select a member to

Re: [PHP] delete query doesnt work

2003-02-07 Thread Sunfire
D]>; <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 5:30 PM Subject: RE: [PHP] delete query doesnt work I've never heard of a variable not getting passed. Make sure that your form element is actually called delete and that it's part of the submitted form. Robbert v

Re: [PHP] delete query doesnt work

2003-02-07 Thread Kevin Stone
Then you just answered your own question. -Kevin - Original Message - From: "Sunfire" <[EMAIL PROTECTED]> To: "Kevin Stone" <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 3:37 PM Subject: Re: [PHP] delete query doesnt work > ok so i mistyped it th

Re: [PHP] delete query doesnt work

2003-02-07 Thread Chris Shiflett
--- Sunfire <[EMAIL PROTECTED]> wrote: > 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? No. It might help to read this: http://www.php.net/manual/en/security.registerglobals.php Chris -- PHP Gener

RE: [PHP] delete query doesnt work

2003-02-07 Thread Van Andel, Robbert
To: [EMAIL PROTECTED] Subject: Re: [PHP] 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

Re: [PHP] delete query doesnt work

2003-02-07 Thread Sunfire
is it possible that submitting a variable from 1 form to another that some wont get carried over? - Original Message - From: "Van Andel, Robbert" <[EMAIL PROTECTED]> To: "Sunfire" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 5:0

RE: [PHP] delete query doesnt work

2003-02-07 Thread Van Andel, Robbert
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

RE: [PHP] delete query doesnt work

2003-02-07 Thread Roedel, Mark
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 s

Re: [PHP] delete query doesnt work

2003-02-07 Thread Kevin Stone
You have a syntax error. Look at your quotes. -Kevin - Original Message - From: "Sunfire" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, February 07, 2003 3:05 PM Subject: [PHP] delete query doesnt work > i have a delete query: > mysql_query("delete from members where compan

RE: [PHP] delete query doesnt work

2003-02-07 Thread Daniel Masson
Maybe you have to use wildcards like: mysql_query("delete from members where company like '%$delete%'");?? Daniel E Massón. Ingeniero de desarrollo [EMAIL PROTECTED] Imagine S.A. Su Aliado Efectivo en Internet www.imagine.com.co (57 1)2182064 - (57 1)61632