Re: Why won`t this delete?

Try: $query_delete=mysql_db_query($SQLConn, $Updstmt); Website4S@aol.com wrote: > 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 > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net