Re: Why won`t this delete?

Um... try this. $Updstmt="delete from EList1 where Email= '$Email' "; mysql_query($updstmt); its the single quotes that make a diff. ----- Original Message ----- From: <Website4S@aol.com> To: <php-general@lists.php.net> Sent: Friday, October 27, 2000 9:19 AM Subject: [PHP] Why won`t this delete? > 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 > >