>
» Blog Archive
comments LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID) WHERE comment_approved = '1' AND comment_type = '' ORDER BY comment_date DESC LIMIT 0 , 3"; $comments = $wpdb->get_results($sql); foreach ($comments as $comment) { $data = $comment->comment_author . " @ " . $comment->post_title; echo "
comment_post_ID) . "\">" . substr($data,0,40) . " ...
"; } ?>