Query Problem

[ttocskcaj]

I have the following database for BigBrother, which is a plugin for CraftBukkit Minecraft server mod.

What I want to do is get an array with `player` as the key and the value as the number of rows in the database for that player where action = 0 or 1.

 

id 	date 	player 	action 	world 	x 	y 	z 	type 	data 	rbacked

 

If that makes sense, what would be the best/most efficient way to do this?

[trq]

If that makes sense

 

Sorry, none at all.

[The Little Guy]

I think he wants this:

 

$sql = mysql_query("select player, count(*) as total from my_table where action in(0,1) group by player");
while($row = mysql_fetch_assoc($sql)){
echo $row['player']."; Total: ".$row['total']."<br>";
}

[ttocskcaj]

I think he wants this:

 

$sql = mysql_query("select player, count(*) as total from my_table where action in(0,1) group by player");
while($row = mysql_fetch_assoc($sql)){
echo $row['player']."; Total: ".$row['total']."<br>";
}

Yup that's exactly what I wanted. Thankyou.