I seem to have an error in my sql statement below
$mysql = mysql_query(
"UPDATE rsvp SET (`userid` = '$userid' , `screenname` = '$screenname' ,
`picture` = '$profile_image_url' , `status` = '$rsvpstatus')
WHERE eventid='$eventid'
IF @@ROWCOUNT=0
INSERT INTO `rsvp` (`userid`, `screenname`, `picture`, `eventid`, `status`)
VALUES (`$userid`, `$screenname`, `$profile_image_url`, `$eventid`, `$rsvpstatus`)"
) or die(mysql_error());
using mysql 5, any ideas?