Select Count (*)

[SFDonovan]

This gives me back the results in some sort of an array, but I don't know why.

$query = $db->sql_query("SELECT COUNT(*) FROM " . $prefix . "_ladderteams WHERE army = 'Axis'");
$result = $db->sql_fetchrow($query) or die("ERROR: $query.".mysql_error());
$axiscount = $result;

Page can be viewed here.

http://www.eto-league.com/modules.php?name=NukeLadder&file=join

I have the same sort of query for the Allied count and as you can see it gives me the same thing.

I only have 8 teams, 4 for Allied and 4 for Axis. Why would I end up with an array?

[drew010]

print_r($result);
and you will see the structure. depends on the db class you are using. the documentation should explain what its doing.
most likely its just from mysql_fetch_row which returns an array of columns from the result row.

[SFDonovan]

Now it is giving me: Array ( [0] => 4 [COUNT(*)] => 4 )

What else could I use beside mysql_fetch_row?

[drew010]

just do
$axiscount = $result[0];