Displaying query results problem

[fimbria]

Hello,

I using the following query, which i have placed in a external class file:

/*************************************************** 
     Get Count of Replies 
     **************************************************/ 

function getCountofReplies($id) 
{ 
         $count = mysql_query("SELECT COUNT(*) FROM ForumReply 
    WHERE TopicID = '$id'") or die(mysql_error()); 
      return $count; 
} 

The problem im having is that im not sure how i display a 'count' result from an external class file. For my other result im using something like:

$rs = $forum->getTopics();

Thanks for any help or advice in advance.

[TTT]

remember that correct sytax is:
SELECT COUNT(*) AS cnt

....

    function getCountofReplies($id)   {  

             $count = mysql_query("SELECT COUNT(*) AS cnt FROM ForumReply  

        WHERE TopicID = '$id'") or die(mysql_error());  

         $count = msyql_result($count,0,0); 
         return $count;  

    }

[fimbria]

so in the main page, would i put something like:

<? 
//include file for the wrapperclass
include "wrapperclass.php";

//make an object of the wrapperclass
$forum=new ForumInterface();

//make db connection
$forumpointer=$forum->connect();

//insert record
$rs = $forum->getTopics();
//$count = $forum->getCountofReplies();
while ($row=mysql_fetch_assoc($rs))
{

?>

<tr class="main">
<td>
<a href='theTopic.php?id=<? echo($row['ID']); ?>'>
<? echo($row['TopicName']); ?>
</a>
<? 
$count = $forum->getCountofReplies($row['ID']);
while (mysql_fetch_array($count))
{

 echo($row['cnt']); 

}
?>
</td>
<td align="center"><? echo($row['TopicAuthor']); ?></td>
<td align="center"><? echo($row['TopicDate']); ?></td>
</tr>


<?  

}

//disconnect to db
$forum->Disconnect($forumpointer);

?>
</table>
</center>


</body>
</html>

or is that the wrong way of doing it, because i can't seem to get it to work...

thanks for advice

[Pilly]

Heres my query that i use. maybe this could help you.

$sql = "
SELECT , count() AS cnt
FROM phplog
Where phplog.field6 ='Lose'
GROUP BY field9
Order BY cnt
DESC
";

[fimbria]

What would be the field that you define, when printing the contents of the count?

e.g.

$row[????]