title: error in mysql statement using IF@@
body: <p>I seem to have an error in my sql statement below</p>
  
  <pre><code>$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());
  </code></pre>
  
  <p>using mysql 5, any ideas?</p>