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:
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>';
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.