Why won`t this delete?
| From: | Website4S at aol dot com | Date: | Fri, 27 Oct 2000 16:19:46 +0000 |
| Subject: | Why won`t this delete? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-22344@lists.php.net to get a copy of this message | ||
Hi,
I have a basic if statement but for some reason it just won`t delete, any
ideas what I`ve done wrong? I have a table called EList1 which has one field
called Email varchar(50) I know the form is working ok because it allows me
to add but not remove.
if ($Selection=="unsubscribe"){
$Updstmt="delete from EList1 where Email=\"$Email\"";
$SQLConn = mysql_connect("", "", "") or die ("Could not
connect to
database");
$db = mysql_select_db("f199102", $SQLConn) or die ("Couldn`t select
database");
$query_delete=mysql_db_query($db, $Updstmt);
if (!$query_delete){
echo "Couldn`t Delete";
}
mysql_close ($SQLConn);
printf("<SCRIPT LANGUAGE='JAVASCRIPT'>alert('You have been removed from
the mailing list.');self.history.back();</SCRIPT>");
}
Thanks in advance
Adrian