get_question.php

<?php
include('../config.php');
$test = mysql_real_escape_string($_GET['test']);

$question = mysql_query("SELECT *, q.id qid, q.question question_text
                         FROM questions q, user_answers ua
                         WHERE q.id != ua.question_id
                           AND ua.test_id = $test
                           AND ua.user_id = $_SESSION[userid]
                         ORDER BY rand()
                         LIMIT 1");

$q = mysql_fetch_assoc($question);

$answers = mysql_query("SELECT * FROM answers WHERE question_id = $q[qid] ORDER BY rand()");
$num = 1;
$letters = array('','a','b','c','d','e','f','g','h');
$answersRadios = '';
while($row = mysql_fetch_assoc($answers)) {
    $letter = strtoupper($letters[$num]);
    $answersRadios .= '<div class="answer-line"><input type="radio" class="questionRadio" name="questionRadio" id="question-radio-'.$letter.'" value="'.$row['id'].'" /> <label class="radio-label" for="question-radio-'.$letter.'">'."<strong>$letter.</strong> $row[answer]".'</label> </div>';
    $num++;
}
if(mysql_num_rows($answers)==0) {
    $answersRadios = '<em>Sorry, but there aren\'t any answers for this question in the database.</em>';
}
$i = array(
    'id'=>$q['qid'],
    'qText'=>$q['question_text'],
    'directions'=>$q['instructions'],
    'answers'=>$answersRadios
);
echo json_encode($i);
?>