/ Published in: PHP
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
function commentCount($type = 'comments'){ if($type == 'comments'): $typeSql = 'comment_type = ""'; $oneText = 'One comment'; $moreText = '% comments'; $noneText = 'No Comments'; elseif($type == 'pings'): $typeSql = 'comment_type != ""'; $oneText = 'One pingback/trackback'; $moreText = '% pingbacks/trackbacks'; $noneText = 'No pinbacks/trackbacks'; elseif($type == 'trackbacks'): $typeSql = 'comment_type = "trackback"'; $oneText = 'One trackback'; $moreText = '% trackbacks'; $noneText = 'No trackbacks'; elseif($type == 'pingbacks'): $typeSql = 'comment_type = "pingback"'; $oneText = 'One pingback'; $moreText = '% pingbacks'; $noneText = 'No pingbacks'; endif; global $wpdb; $result = $wpdb->get_var(' SELECT COUNT(comment_ID) FROM '.$wpdb->comments.' WHERE '.$typeSql.' AND comment_approved="1" AND comment_post_ID= '.get_the_ID() ); if($result == 0): elseif($result == 1): elseif($result > 1): endif; }