Help with this bit of code please!

[Prince]

Something is wrong here...whether the email address exists in the database or not it comes back as if it does exist. It's supposed to come back with a different result if the address exists in the database.

Anyone?


if($new_sub == 'unsub') // User wants to unsubscribe the letter
{
$query = "DELETE FROM ${prefix}_newsletter WHERE email='$new_email'";
if(!mysql_query($query))
{
echo mysql_errno(). ": ".mysql_error(). "<br>";
CloseTable();
include("footer.php");
return;
}
cgiCenter();
echo _new_unsbuok;
cgiBR();
cgiLinkM("index", "def", _new_clickhere);
cgiCenter(1);
CloseTable();
include("footer.php");
return;
}

CloseTable();
include("footer.php");
}

[Issvar]

The SQl query is valid, it deletes 0 or more lines. If you want to check if 0 lines were removed use mysql_affected_rows()