OwlCyberSecurity - MANAGER

Edit File: Serie.php

<?PHP

include("Connect.php");

// nombre d'�l�ments � extraire al�atoirement
$number_question = $_POST ["numberofQ"];
$category_id = $_POST ["category_id"];

$cat_select = " category_id = '" . $category_id ."' AND ";
if ($category_id == 0) {
	$cat_select = "";
}
$query = "SELECT *,'Type_id.name' FROM Question,Type WHERE " . $cat_select . " Question.Type_id = Type.id_type ORDER BY rand() LIMIT " . $number_question;

$results = mysql_query($query);

echo "<LISTE>\n";

while($line = mysql_fetch_assoc($results)) {
echo "  <QA>\n";
	echo "    <type>" . $line["name"] . "</type>\n";
	echo "    <question>" . $line["question"] . "</question>\n";
	echo "    <difficulty>" . $line["difficulty"] . "</difficulty>\n";
	echo "    <timer>" . $line["timer"] . "</timer>\n";
	echo "    <source>" . $line["source"] . "</source>\n";
	echo "    <id>" . $line["id"] . "</id>\n";
	
	//True answer
	$queryA = "SELECT * FROM Answer WHERE question_id =" . $line["id"] . " AND truefalse=1";
	$resultsA = mysql_query($queryA);

while($lineA = mysql_fetch_assoc($resultsA)) {
	echo "    <answer>\n";
		echo "      <name>" . $lineA["answer"] . "</name>\n";
		echo "      <truefalse>" . $lineA["truefalse"] . "</truefalse>\n";
	echo "    </answer>\n";
	}
	
	//false answers
	$queryA = "SELECT * FROM Answer WHERE question_id =" . $line["id"] . " AND truefalse=0 ORDER BY rand() LIMIT 3";
	$resultsA = mysql_query($queryA);

echo "  </QA>\n";
}

echo "</LISTE>\n";

mysql_close($link);