Es domāt', ka kaut kā šitā...
$query = mysql_query(" SELECT COUNT(IF(`type` = 'payment', 1, NULL)) AS `payment`, COUNT(IF(`type` = 'bug', 1, NULL)) AS `bug`, COUNT(IF(`type` = 'advice', 1, NULL)) AS `advice` FROM `report` ") or exit( mysql_query() );
$database = mysql_fetch_row( $query );
echo $database['payment'];