如何使此函数仅显示最新的5条注释？
function showLatestComments() {
global $wpdb;
$sql = "
SELECT DISTINCT comment_post_ID, comment_author, comment_date_gmt, comment_approved, SUBSTRING(comment_content,1,100) AS com_excerpt
FROM $wpdb->comments
WHERE comment_approved = \'1\'
ORDER BY comment_date_gmt DESC
LIMIT 5";
$comments = $wpdb->get_results($sql);
$output .= \'<h2>Latest student perspectives <img src="/wp-content/themes/blue-and-grey/images/hmepage-tri.png" class="class3" /></h2>
<ul id="comm">\';
foreach ($comments as $comment) {
$output .= \'<li><strong>\'. $comment->comment_author . \' said</strong> : "\' . strip_tags($comment->com_excerpt). \'..."</li>\';
}
$output .= \'</ul>\';
echo $output;
}//end function
SO网友:Bainternet
您发布的函数被限制为5条注释，这意味着它应该可以工作，但不管怎样，当您可以使用本机get\\u comments函数时，不需要自定义SQL查询
function showLatestComments() {
$comments = get_comments(array(
\'status\' => \'approve\',
\'number\' => \'5\'
)
);
$output .= \'<h2>Latest student perspectives <img src="/wp-content/themes/blue-and-grey/images/hmepage-tri.png" class="class3" /></h2>
<ul id="comm">\';
foreach ($comments as $comment) {
$output .= \'<li><strong>\'. $comment->comment_author . \' said</strong> : "\' . substr(strip_tags($comment->content),0,99). \'..."</li>\';
}
$output .= \'</ul>\';
echo $output;
}//end function
