update script not using passed data

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]

if visName={$_GET[‘visName’]} is not an integer, which i’m guessing its not, then it needs quotes around it like so: visName=’{$_GET[‘visName’]}’

hope that helps

Red :wink:

Sponsor our Newsletter | Privacy Policy | Terms of Service