your count statement:
COUNT(clients.StagingDate) recordcount
is not correct.
it should be:
COUNT(clients.StagingDate) as recordCount
the group by is also wrong:
GROUP BY accountants.AccountantID, clients.AccountantID
should be:
GROUP BY DATE_FORMAT(StagingDate, '%Y-%m-%d')
to echo the count, you don't use the count function in the php code, you simply echo the recordCount alias:
<?php echo $row_rsAccountants['recordCount']; ?>
If you would like 1 on 1 help setting this up, we can help through a premiere support appointment:
http://www.webassist.com/premier_request.php