[aminp30]

Originally Posted by cellarius

What's the exact code you're using?

I use two table so my code is something like this:

PHP Code:

$result = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "questions");
$i=0;
    while ( $db_field = mysql_fetch_assoc($result) ) {
        $i=$i+1;
        $ID=$db_field['ID'];
        $resulta = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "answers WHERE question_ID = $ID ");
        //mysql_set_charset('utf8');
        $j=0;
        while ( $db_fielda = mysql_fetch_assoc($resulta) ) {
            $j=$j+1;
            $answer[$j] = $db_fielda['answer'];
        }

        echo '<tr '. (($i % 2) == 1 ? 'class="alt"' : '').'><td>'.$i.'</td><td>'.$vbulletin->userinfo['username'].'</td><td>'.$db_field['text'].'</td><td>
            <input type="radio" name="q'.$i.'" value="'.$answer[1].'"'.($answer[1] == $db_field['answer']? ' checked ' : '').'disabled> '. $answer[1].'  |  
            <input type="radio" name="q'.$i.'" value="'.$answer[2].'"'.($answer[2] == $db_field['answer']? ' checked ' : '').'disabled> '. $answer[2].'  |  
            <input type="radio" name="q'.$i.'" value="'.$answer[3].'"'.($answer[3] == $db_field['answer']? ' checked ' : '').'disabled> '. $answer[3].'  |  
            <input type="radio" name="q'.$i.'" value="'.$answer[4].'"'.($answer[4] == $db_field['answer']? ' checked ' : '').'disabled> '. $answer[4].'
            </td><td>'.$db_field['score'].'</td></tr>';
        $answer = array();
    }

    mysql_close($db_handle);