The following code should “produce” a url (example) like: http://www.ourdomain.com/unsubscribe.php?feedback_id=101&visName=John which it does, but the script doesn’t execute, it throws an error. If only the feedback_id is passed, it works. What’s happening with the second (visName). No problem with db tables. Thanks in advance for your help.
[code]$edit = “UPDATE feedback SET notify=’’ WHERE feedback_id={$_GET[‘feedback_id’]} AND visName={$_GET[‘visName’]};”;
$eresult = mysql_query($edit);
//show result to user
if(mysql_affected_rows() == 1) {
echo ‘
You will no longer receive email notification of posts to: ’ . $qrow[‘art_title’] . ’ This does not affect any other conversations you might be following.
’;}else {
echo ‘
error
’;}[/code]