checkbox deletions
| From: | Richard Bradley | Date: | Wed, 13 Sep 2000 19:08:00 +0000 |
| Subject: | checkbox deletions | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-16621@lists.php.net to get a copy of this message | ||
I've developed this script but it does not delete the items from mysql
database that are marked Checked on the form. Any suggestions, maybe
it's because I need to write to the database "checked" upon submitting
the form.
<?php
$connection = mysql_connect("mysql.myhost.net","myusername","XXXXXX")
or die ("Couldn't open connection to the server");
$db = mysql_select_db("mainyl_db", $connection) or die ("Couldn't
connect to the database");
$sql = "DELETE FROM FORM_EMAILS WHERE DELETE_CONTACT = 'CHECKED'";
$sql_result = mysql_query($sql,$connection) or die ("Could't execute query.");
header("Location: http://web5.yourlink.net/yourlink/formdata/delete_items.php");
?>
Richard
Senior Site Developer/YourLink, inc.