9 20
Display recent comments on your Wordpress blog
Sometimes you want to display a Wordpress feature, such as recent comments, tags, etc., without using a widget. For me, it’s occassionally easier to STYLE, especially if I’m not using a Theme that I built or that I’m familiar with.
A great code around is shown below, courtesy of to Kyle Eslick and found on wprecipes. I’ve used it on some sites and I find it works great. ONE NOTE: if you want less than 10 comments, simply change the code to a lesser number.
php 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 10"; $comments = $wpdb->get_results($sql); $output = $pre_HTML; $output .= "\n
- ";
foreach ($comments as $comment) {
$output .= "\n
- ".strip_tags($comment->comment_author) .":" . "ID)."#comment-" . $comment->comment_ID . "" title="on ".$comment->post_title . "">" . strip_tags($comment->com_excerpt)." "; } $output .= "\n
8 17
Kawasaki Motorcycle Web Updates
In an effort to show potential clients the BROAD range of skills I have, I am starting a daily ‘what I’m doing’ post.
Today, I had the usual struggle to dive back into work after a week off on the Washington Coast (like to see some pictures, click here). Once I got started, I got quite a bit accomplished.
Long-time client, Beartooth Kawasaki (www.beartoothkawasaki.com) needed the annual product updates done to their various websites. It takes a bit of time but it’s enjoyable because I have been doing it for many years.
Kawasaki Motorcycle website edits
Skills required on this particular job include an understanding and ability to code in PHP, as well as HTML and CSS, image manipulation and attention to detail.
Have a job like this? Contact me today to find out how I can help.