Hello all,

I am trying to do a simple count of how many individuals have agreed to the terms on a form and how many have disagreed now I use the count function via query but I keep on receiving back this info on the php page

"Yes":( Resource id #3)
"No":( Resource id #4)

the query is as such: $res = mysql_query("SELECT count(list) FROM check_list WHERE list='Yes'");

IT seems to work but Its not providing me with the appropriate number of records that have individuals agreeing to the form...

Please advice?

You need to extract the value from the resource. $res is an array, even when there's only one array member: that's just how resultsets get returned. So $res actually represents

$count => 'your answer'

...and not 'your answer'. Try something like:

$answer = mysql_result($res,0,0);

Dan

Dan, Thanks a bunch... it works like a charm...

dungey