[SOLVED] counting from a database...

[seany123]

basically i want to echo how many people in my "players" table have a gang_id that is = to $gang['id']

 

 

that it if anyone can help that would be good.

[Cosizzle]

 

 

$count = 0;
while (gang_id == $gang['id']) {
$count+=1;
}
echo $count

[Alex]

$result = mysql_query("Select COUNT(gang_id) FROM `players` WHERE gang_id='" . $gang['id'] . "'");
$row = mysql_fetch_assoc($result);
echo $row['COUNT(gang_id)'];

[cunoodle2]

<?php

$query = "Select COUNT(gang_id) FROM players WHERE gang_id = '".$gang['id']."';";

$result = mysql_query($query) or die(mysql_error());

$row = mysql_fetch_array($result);

echo "There are ". $row['COUNT(gang_id)'] ." results.";

?>

 

Or something like that