[SOLVED] help.

[seany123]

i have a table in my database called players... inside players i have a value called "prison"

 

basically i wanna know how to echo the amount of players have prison >= 1.

 

 

 

[revraz]

What is the field name that holds the "prison" data?

 

Just do a SELECT COUNT on the table where your field name = "prison"

[jonsjava]

SELECT COUNT(`prison`) as `total_in_jail` FROM `players` WHERE `prison` >= 1;

[premiso]

$sql = "SELECT COUNT(prison) FROM players WHERE prison > 0";
$result = mysql_query($sql);
$prisonCount = mysql_result($result, 0, 0);

echo $prisonCount . "<br />";

 

Basic PHP and MySQL, I would suggest reading a tutorial on that.

[mtoynbee]

SELECT COUNT(*) AS player_count FROM players WHERE prison >= 1