| Forces of Good |
|
$db = mysql_connect("localhost", "root", "time8bomb");
mysql_select_db("stratego",$db);
$query = "select force,armyname,id,wins from armylist where force=1 order by wins,armyname";
$result = mysql_query("$query",$db);
while ($myrow = mysql_fetch_row($result)) {
$query = "select name from trade where id = $myrow[2]";
$result1 = mysql_query("$query",$db);
$name = mysql_fetch_row($result1);
$army = str_replace(" ", "%20", $myrow[1]);
echo " | | $myrow[1] ($myrow[3]) | ( $name[0] ) | \n";
}
?>
|
| Forces of Evil |
|
$query = "select force,armyname,id from armylist where force=2 order by armyname";
$result = mysql_query("$query",$db);
while ($myrow = mysql_fetch_row($result)) {
$query = "select name from trade where id = $myrow[2]";
$result1 = mysql_query("$query",$db);
$name = mysql_fetch_row($result1);
$warmy = str_replace("'", "''", $myrow[1]);
$query1 = "select game from gametrack where winner = $myrow[2] and warmy='$warmy'";
$result2 = mysql_query("$query1",$db);
$wins = mysql_num_rows($result2);
$army = str_replace(" ", "%20", $myrow[1]);
echo " | | $myrow[1] ($wins) | ( $name[0] ) | \n";
}
?>
|