worldpay_vars.php

  $country = '';
  $sql = "select qst.system_name as system_name, qst.question as question, ans.answer as answer from " . EVENTS_ANSWER_TABLE . " ans inner join " . EVENTS_QUESTION_TABLE . " qst on ans.question_id = qst.id where qst.system_name = 'country' and ans.attendee_id = " . $attendee_id;
  $questions = $wpdb->get_results($sql, ARRAY_A);
  if ($wpdb->num_rows > 0 && $wpdb->last_result[0]->question != NULL) {
    foreach ($questions as $q) {
      $country = $q['answer'];
    }
  }