RE: [PHP] Why won`t this delete?

Regarding this line of code: > $Updstmt="delete from EList1 where Email=\"$Email\""; > Try this instead > $Updstmt="delete from EList1 where Email==\"$Email\""; > When you use a single equals sign (=) you are setting the value on the left equal to the value on the right. When you use the doubel euals (==) you are actually telling it to compare the two. Hope that's it. good luck, Ryan Sander Web Developer 330-580-8549 Ryan.Sander@cantonrep.com http://cantonrep.com > ---------- > From: Website4S@aol.com > Sent: Friday, October 27, 2000 12:19 PM > To: php-general@lists.php.net > 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 > >