BattleField
| Username | Army Size | Gold | Rank
|
include "config.php";
function total(){
$start = "25";
$sql = mysql_query("SELECT * FROM users ORDER BY rank DESC LIMIT 0,30");
while($row = mysql_fetch_assoc($sql)){
}
$att = $row['attack'];
$def = $row['defence'];
$mat = $row['mattack'];
$mde = $row['mdefence'];
$unt = $row['untrained'];
$mun = $row['muntrained'];
$spy = $row['spy'];
$sen = $row['sentry'];
$sum = $att + $def + $mat + $mde + $unt + $mun + $spy + $sen;
return $sum;
}
?>
$start = "25";
$sql = mysql_query("SELECT * FROM users ORDER BY rank DESC LIMIT 0,30");
while($row = mysql_fetch_assoc($sql)){
echo "
| {$row['username']} | ";
echo "" . total() .
" |
";
}
?>