$sql = mysql_query("SELECT COUNT(id) as total, (SELECT COUNT(id) FROM game_rps_stats WHERE result = 1) as total_rock, (SELECT COUNT(id) FROM game_rps_stats WHERE result = 2) as total_paper, (SELECT COUNT(id) FROM game_rps_stats WHERE result = 3) as total_sissors FROM game_rps_stats") or print(mysql_error());
?>
=round((mysql_result($sql, 0, "total_rock") / mysql_result($sql, 0, "total")) * 100, 2);?>% |
=round((mysql_result($sql, 0, "total_paper") / mysql_result($sql, 0, "total")) * 100, 2);?>% |
=round((mysql_result($sql, 0, "total_sissors") / mysql_result($sql, 0, "total")) * 100, 2);?>% |