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" <[EMAIL PROTECTED]>
To: "Sunfire" <[EMAIL PROTECTED]>; <[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 van Andel
-----Original Message-----
From: Sunfire [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 07, 2003 2:35 PM
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 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" <[EMAIL PROTECTED]>
To: "Sunfire" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
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:[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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
