OwlCyberSecurity - MANAGER

Edit File: Category.php

<?PHP

include("Connect.php");

$player_id = $_POST ["player_id"];
     
$query = "SELECT * FROM Category";
$results = mysql_query($query);

echo "<LISTE>\n";

echo "  <Category>\n";
echo "    <id>0</id>\n";	
echo "    <name>G�n�ral</name>\n";	
$query2 = "SELECT score FROM Player_score WHERE player_id='" . $player_id . "' AND category_id='0'";
$results2 = mysql_query($query2);
while($line2 = mysql_fetch_assoc($results2)) {
	echo "    <bestscore>" . $line2["score"] . "</bestscore>\n";	
}
echo "  </Category>\n";

while($line = mysql_fetch_assoc($results)) {
	echo "  <Category>\n";
	echo "    <id>" . $line["id"] . "</id>\n";	
	echo "    <name>" . $line["name"] . "</name>\n";

$query2 = "SELECT score FROM Player_score WHERE player_id='" . $player_id . "' AND category_id='" . $line["id"] . "'";
		$results2 = mysql_query($query2);
		while($line2 = mysql_fetch_assoc($results2)) {
			echo "    <bestscore>" . $line2["score"] . "</bestscore>\n";	
		}
	echo "  </Category>\n";
}

echo "</LISTE>\n";

mysql_close($link);