simple query output in php?

[eightonesix]

hi everyone... i apologize because i'm not very familiar with php, but i was wondering if there was a way to accomplish a simple task with php.

our non-profit group is holding a training session in may. i have set up an online registration system with mysql. what i'd like to do is have a script that will count the number of people who have paid and tell me how many table entries say yes. the output should just be the number.

with a ssi, i'm going to put this on our homepage so registrants know if spots are available.

is this possible? or is there an easier way to do it?

[_off_axis_]

if the field that you want to look at to see if they paid is called "paid", this is an example of how to select users that have paid and use mysql_num_rows to count how many there are

$query = mysql_query("SELECT * FROM users WHERE paid='yes'");
$num_paid = mysql_num_rows($query);

$num_paid is the number of users who have paid

[eightonesix]

you rock, axis! it worked!

thanks a bunch!