Then that would be something like this.
PHP Code:
//update the status table
$query = "INSERT INTO member_status(mem_id, status)
VALUES ('$userid', '$status')
ON DUPLICATE KEY UPDATE status = '$status' ";
$retvalu=mysql_query($query,$link) or die(mysql_error());