hey guys,
Just finishing up a wordpress theme and I have written some code to display the 5 most recent comments in the side bar:
Anyways it all works fine but it doesn't seem to generate the correct link for the users gravatar. The image comes up fine in the actual comments on the post itself. I can't see what I have done wrong, so hopefully someone a bit more experience then me can help out. Probably something simple but I just cant see it. Thanks.Code:global $wpdb; $sql = "SELECT DISTINCT ID, post_title, post_password, comment_ID, comment_post_ID, comment_author, comment_date_gmt, comment_approved, comment_type,comment_author_url, SUBSTRING(comment_content,1,30) AS com_excerpt FROM $wpdb->comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID) WHERE comment_approved = '1' AND comment_type = '' AND post_password = '' ORDER BY comment_date_gmt DESC LIMIT 5"; $comments = $wpdb->get_results($sql); $output = $pre_HTML; #$output .= "\n<ul>"; #bullet points foreach ($comments as $comment) { $line = "\n<li>"." ".strip_tags($comment->comment_author) .":" . "<a href=\"" . get_permalink($comment->ID) . "#comment-" . $comment->comment_ID . "\" title=\"on " . $comment->post_title . "\">" . strip_tags($comment->post_title) ."</a></li>"; $linelength = strlen($comment->comment_author.":".$comment->post_title);#limit is 35 if ($linelength > 35){ $commentauthoravatar[] = get_avatar(get_comment_author_email($comment->comment_ID), 20, $default, $comment->comment_author).'<br>'.'<br>';


LinkBack URL
About LinkBacks
Reply With Quote