Here's the code:
## counts battles, wins, losses and draws and prints them ##
Code: Select all
<?php
include "inc/dbstart.php";
mysql_select_db("hivemind");
$countquery = "SELECT COUNT(*) as numRows FROM wars";
$count_played = mysql_result(mysql_query($countquery), 0, "numRows") or die(mysql_error());
$countquery2 = "SELECT COUNT(*) as numRows FROM wars WHERE status='won'";
$count_won = mysql_result(mysql_query($countquery2), 0, "numRows") or die(mysql_error());
$countquery3 = "SELECT COUNT(*) as numRows FROM wars WHERE status='lost'";
$count_lost = mysql_result(mysql_query($countquery3), 0, "numRows") or die(mysql_error());
$countquery4 = "SELECT COUNT(*) as numRows FROM wars WHERE status='draw'";
$count_draw = mysql_result(mysql_query($countquery4), 0, "numRows") or die(mysql_error());
print "played: $count_played<br>\n";
print "won: $count_won<br>\n";
print "lost $count_lost<br>\n";
print "even: $count_draw<br>\n";
mysql_close();
?>