Support » Plugins » Template with Custom Select Query

  • Resolved jacob_boetter


    I am trying to make a template that shows a custom select query. It all works pretty neat so far, but one thing is still wrong: It shows everything, but the comments (The meta data under the post, ala “32 Comments”

    This is my code:

    Template Name: High Risks

    <?php get_header();

    $query="SELECT * FROM wp_questions";
    while ($row=mysql_fetch_assoc($result)) {

    $p="SELECT wposts.* FROM $wpdb->posts wposts WHERE (wposts.ID = ".implode(" OR wposts.ID = ",$p).") ORDER BY wposts.post_date DESC";
    $pageposts = $wpdb->get_results("".$p."", OBJECT);

    <div id="content" class="narrowcolumn">

    <?php if ($pageposts): ?>
    <?php foreach ($pageposts as $post): ?>
    <?php setup_postdata($post); ?>

    <div class="post" id="post-<?php the_ID(); ?>">
    <h2><a href="<?php the_permalink() ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>"><?php the_title(); ?></a> <script type="text/javascript">slvShowNewIndicator(<?php print(mysql2timestamp($post->post_date)); ?>);</script></h2>
    <small><?php the_time('F jS, Y') ?> <!-- by <?php the_author() ?> --></small>

    <div class="entry">
    <?php the_content('Read the rest of this entry &raquo;'); ?>

    <p class="postmetadata">Posted by <?php the_author_firstname(); ?> <?php the_author_lastname(); ?> in <?php the_category(', ') ?> | <?php edit_post_link('Edit', '', ' | '); ?> <?php comments_popup_link('No Comments »', '1 Comment »', '% Comments »'); ?></p>

    <?php endforeach; ?>

    <?php else: ?>
    <h2 class=”center”>Not Found</h2>
    <p class=”center”>Sorry, but you are looking for something that isn’t here.
    <?php include (TEMPLATEPATH . “/searchform.php”); ?>
    <?php endif; ?>


    <?php get_sidebar(); ?>

    <?php get_footer(); ?>`

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘Template with Custom Select Query’ is closed to new replies.