• Recent Posts

  • Popular Posts

      get_results("SELECT comment_count,ID,post_title FROM $wpdb->posts ORDER BY comment_count DESC LIMIT 0 , 7"); foreach ($result as $topten) { $postid = $topten->ID; $title = $topten->post_title; $commentcount = $topten->comment_count; if ($commentcount != 0) { ?>
  • Recent Comments

    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 7"; $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
    "; $output .= $post_HTML=''; echo $output;?>
. Template by Towfiq I.