1) $r=rand(0,$rows-1); $test_id=mysql_result($result,$r,"ID"); $test_num = mysql_result($result,$r,"NUM"); $test_text = mysql_result($result,$r,"TEXT"); $sql="SELECT * FROM QUESTION WHERE TEST_ID=".$test_id." ORDER BY NUM"; $result = mysql_query($sql); $rows=0; if ($result) $rows = mysql_num_rows($result); if ($rows==0) continue; $r=0; if ($rows>1) $r=rand(0,$rows-1); $question_id=mysql_result($result,$r,"ID"); $question_num = mysql_result($result,$r,"NUM"); $question_text = str_towords(mysql_result($result,$r,"TEXT")); $question_type = mysql_result($result,$r,"TYPE"); // $query = "SELECT NAME FROM QTYPE WHERE TYPE=".$question_type; // echo $query; // $result = MYSQL_QUERY($query); // $question_type_text = mysql_result($result,0,"NAME"); break; } mysql_close(); require 'u0-6.php3'; ?>