Re: Why won`t this delete?

It's true that "==" compares values in OOP languages, but in SQL, it doesn't. In SQL, values are changed with the 'update' statement and the '=' sign compares integers. However, you brought up an interesting point about the syntax of the SQL statement. Because you are comparing strings try the following: $Updstmt="delete from EList1 where Email like \"$Email\""; "Sander, Ryan" wrote: > 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 > > > > > > -- > 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