Support

October 25, 2013 at 3:50 pm

First, you would need to grab the questions and answers for that attendee (insert into the template.php at line 60 of Dean’s template file):

$questions = $wpdb->get_results("select 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 ans.attendee_id = ".$attendee_id, ARRAY_A);

Then search through the questions to find the one that matches (you may need to adjust the $needle to match your question):

$needle = "Company Name";
$found = NULL;
foreach ($questions as $key=>$question) {
  if ($question['question'] == $needle) $found = $key;
}
$company_name = !empty($found) ? $questions[$found]['answer'] : '';

Then you can use $company_name in the ‘Bill to: ‘ section:

$pdf->Cell(50, 5, $company_name, 0, 1, 'L');