<?php
	require 'db.php';

 		$sqltran = mysqli_query($con, "SELECT * FROM Users ORDER BY SkillRating DESC ")or die(mysqli_error($con));
		$arrVal = array();

		$i=1;
 		while ($rowList = mysqli_fetch_array($sqltran)) {

						$name = array(
								'num' => $i,
 	 		 	 				'player'=> $rowList['UserName'],
	 		 	 				'puntaje'=> round($rowList['SkillRating']),
	 		 	 				'ganadas'=> $rowList['Wins'],
	 		 	 				'perdidas'=> $rowList['Loses']
 	 		 	 			);


							array_push($arrVal, $name);
			$i++;
	 	}
	 		 echo  json_encode($arrVal);


	 	mysqli_close($con);
?>