[Resolved] Counting

[fean0r]

on my mysql database I have a feild called userlevel

in this feild there can be

user
team
admin

various random activation codes

How can I count and display all of these?

eg:

echo $total_admin
echo $total_team
echo $total_user
echo $total_other

also whats the command to show total number of rows?

If you can explain how I do a count I suppose I could total all the main 3 and take it from the number of rows to get $total_other

[Gary_King]

For counting the number of rows, check this out:

http://www.php.net/mysql_num_rows

[fean0r]

k so now how do I count the users etc?

[stolzyboy]

something like this should get you started:

<?
$query = "select count(user) as counted_user, 
count(team) as counted_team, 
count(admin) as counted_admin, 
count(other) as counted_other from userlevel;";
$result = mysql_query($result) or die(mysql_error());

$row = mysql_fetch_array($result);

echo "There are " . $row['counted_user'] . " in user<br>";
echo "There are " . $row['counted_team'] . " in team<br>";
echo "There are " . $row['counted_admin'] . " in admin<br>";
echo "There are " . $row['counted_other'] . " in other<br>";
?>

[fean0r]

trying now

[fean0r]

$u = "0";
$t = "0";
$a = "0";
$o = "0";
$query_items = "SELECT * FROM user ORDER BY username";
$items = mysql_query($query_items) or die(mysql_error());
$row_items = mysql_fetch_assoc($items);
do {
if ($row_items['userlevel'] == "user") { $u = $u+1; }
if ($row_items['userlevel'] == "team") { $t = $t+1; }
if ($row_items['userlevel'] == "admin") { $a = $a+1; }
if ($row_items['userlevel'] == "admin") { $o = $o+1; }
}
while ($row_items = mysql_fetch_assoc($items));
mysql_close();

I just used a loop!

Thanks all