Error With Tabbed Widget PhP

Discussion in 'PHP' started by theblurr5495, Dec 14, 2009.

  1. #1
    If you visit my Web Journey you can see that the tabbed widget works fine function wise, but it doesn't display any of the content such as recent posts. Any idea why this code is wrong?

    <div id="tabvanilla" class="tabbedwidget">

    <ul class="tabnav">
    <li><a href="#popular">Recent Posts</a></li>
    <li><a href="#recent">Recent Comments</a></li>
    <li><a href="#featured">Top Commentators</a></li>
    </ul>

    <div id="popular" class="tabdiv">
    <?php query_posts('showposts=10'); ?>
    <ul><?php while (have_posts()) : the_post(); ?>
    <li><a href="<?php the_permalink() ?>"><?php the_title(); ?></a></li>
    <?php endwhile;?></ul>
    </div><!--/popular-->

    <div id="recent" class="tabdiv">
    <?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<ul>";
    foreach ($comments as $comment) {
    $output .= "\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->com_excerpt)
    ."</a></li>";
    }
    $output .= "\n</ul>";
    $output .= $post_HTML;
    echo $output;?>
    </div><!--/recent-->
    <div id="featured" class="tabdiv">
    <?php if ( is_home() ) { ?>
    < ?php
    if(function_exists('fp_get_topcommenters')) {
    echo fp_get_topcommenters();
    }
    ?>
    <?php } ?>
    </div><!--featured-->

    </div><!--/widget-->
     
    Last edited: Dec 14, 2009
    theblurr5495, Dec 14, 2009 IP
  2. rockyg

    rockyg Peon

    Messages:
    230
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Could you post the code please??? Would be helpful :D
     
    rockyg, Dec 14, 2009 IP
  3. theblurr5495

    theblurr5495 Active Member

    Messages:
    436
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    60
    #3
    LOL whoops; posted
     
    theblurr5495, Dec 14, 2009 IP
  4. theblurr5495

    theblurr5495 Active Member

    Messages:
    436
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    60
    #4
    Anyone know what's wrong.
     
    theblurr5495, Dec 15, 2009 IP
  5. Wogan

    Wogan Peon

    Messages:
    81
    Likes Received:
    3
    Best Answers:
    2
    Trophy Points:
    0
    #5
    Should be working ... try post_rewind(); before doing anything else?
     
    Wogan, Dec 16, 2009 IP
  6. theblurr5495

    theblurr5495 Active Member

    Messages:
    436
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    60
    #6
    Where do I add post_rewind();
     
    theblurr5495, Dec 18, 2009 IP
  7. Wogan

    Wogan Peon

    Messages:
    81
    Likes Received:
    3
    Best Answers:
    2
    Trophy Points:
    0
    #7
    Before anything else...
     
    Wogan, Dec 19, 2009 IP