RE: [PHP] delete query doesnt work

Your problem is that form variables only exist on the page you POST your data to (or GET). You have a "confirmation" as that page. After your confirmation, $delete is empty on any other pages! If you want to pass it, then add it to a link or put it into another form as a hidden element or add it to a session or something. _YOU_ have to pass the $delete variable around to each page if you want it to exist! ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > -----Original Message----- > From: Sunfire [mailto:rusty_81@msn.com] > Sent: Friday, February 07, 2003 6:16 PM > To: php-general@lists.php.net > Subject: Re: [PHP] delete query doesnt work > > ok i changed the endings to those to </option> but still keep getting > blank > variable in the end for $delete in the delete query > > > ----- Original Message ----- > From: "Van Andel, Robbert" <RVanAndel@chartercom.com> > To: "Sunfire" <rusty_81@msn.com>; <php-general@lists.php.net> > Sent: Friday, February 07, 2003 5:51 PM > Subject: RE: [PHP] delete query doesnt work > > > You're form code is incorrect. > > <option value="">select a member to delete<br> > > should read > > <option value="">select a member to delete</option> > > The line: > > value=\"$DeleteMember[Company]\">\"$DeleteMember[Company]\"<br>"; > > should read > > value=\"$DeleteMember[Company]\">\"$DeleteMember[Company]\"</option>"; > > Robbert van Andel > > > -----Original Message----- > From: Sunfire [mailto:rusty_81@msn.com] > Sent: Friday, February 07, 2003 2:56 PM > To: php-general@lists.php.net > 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 > //delete > <form action="delete.php" method="post"> > <select name="delete"> > <option value="">select a member to delete<br> > <?php > $query=mysql_query("select company from members"); > while($DeleteMember=mysql_fetch_array($query)){ > echo "<option > > value=\"$DeleteMember[Company]\">\"$DeleteMember[Company]\"<br>"; > ?> > </select> > </form> > > the second form now is a check box with a submit button to confirm they > want > it deleted: > <form action="delete2.php" method="post"> > are you really sure you want to delete the member below? > <input type="checkbox" name="deleteMember">if you want to delete > <?php > echo > "$delete" ?> > > <input type="submit" value="yes"> > <a href="main.php">cancel</a> > </form> > //now the code to actually use $delete in a query run: > <?php > if($DeleteMember=="on"){ > mysql_query("delete from members where > company='$delete'"); > } else { > echo "cant delete member the check box wasnt checked"; > } > ?> > > dont know why it doesnt work...any ideas? > > ----- Original Message ----- > From: "Van Andel, Robbert" <RVanAndel@chartercom.com> > To: "Sunfire" <rusty_81@msn.com>; <php-general@lists.php.net> > 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 van Andel > > > -----Original Message----- > From: Sunfire [mailto:rusty_81@msn.com] > Sent: Friday, February 07, 2003 2:35 PM > To: php-general@lists.php.net > 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 where company = > 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? > > ----- Original Message ----- > From: "Van Andel, Robbert" <RVanAndel@chartercom.com> > To: "Sunfire" <rusty_81@msn.com>; <php-general@lists.php.net> > Sent: Friday, February 07, 2003 5:05 PM > Subject: RE: [PHP] delete query doesnt work > > > 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:rusty_81@msn.com] > Sent: Friday, February 07, 2003 2:06 PM > To: php-general@lists.php.net > 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 > > > > -- > 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