WordPress - Multiple Loops & DBs on 1 page

skipcollege

Hello, I have multiple separate installations of WordPress blogs on my website in directories such as /blog, /news & /journal. In my main site (non-wp) index.php page I am trying to put multiple WordPress Loops to connect to each individual blog and display the most recent post from each. Like a preview of each of my different blogs for the people who visit my home page and to keep fresh content on my home page.

I successfully made it get the most recent post from one blog. But once I add a second WordPress Loop into the page it just returns a duplicate display of the same data from the first blog, even though in the second Loop the settings are set for the second blog.

To me it seems as though the connection to the database from the first Loop is still open for the second Loop or some variables are not being reset from the first Loop before the second Loop starts.

I've searched for a while and have not found a solution.

I've asked for help on the WordPress Support Forum as well but no one has known how to fix this yet. Others have suggested using feeds but I would really like to just use the WP Loop. See that thread here: http://wordpress.org/support/topic/50044

Here is my index.php code...

<?php
require_once('news/wp-blog-header.php');
?>

<?php query_posts('posts_per_page=1'); ?>
<h1 id="header"><a>" title="<?php bloginfo('name'); ?>"><?php bloginfo('name'); ?></a></h1>

<!-- // loop start -->
<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
<?php the_date('m-d-y', '<h2>','</h2>'); ?>
<h3 id="post-<?php the_ID(); ?>"><a>" rel="bookmark" title="Permanent Link: <?php the_title(); ?>"><?php the_title(); ?></a></h3>

<?php the_excerpt(); ?>

<?php link_pages('Pages: ', '', 'number') ?>

<em>Posted by <strong><?php the_author() ?></strong></em>
Filed under: <?php the_category(',') ?>

<?php comments_popup_link('0 comments', '1 comment', '% comments') ?>

<?php comments_template(); ?>

<!-- // this is just the end of the motor - don't touch that line either :) -->
<?php endwhile; else: ?>
<?php _e('Sorry, no posts matched your criteria.'); ?>
<?php endif; ?>

<br><br>

<?php
require_once('journal/wp-blog-header.php');
?>

<?php query_posts('posts_per_page=1'); ?>
<h1 id="header"><a>" title="<?php bloginfo('name'); ?>"><?php bloginfo('name'); ?></a></h1>

<!-- // loop start -->
<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
<?php the_date('m-d-y', '<h2>','</h2>'); ?>
<h3 id="post-<?php the_ID(); ?>"><a>" rel="bookmark" title="Permanent Link: <?php the_title(); ?>"><?php the_title(); ?></a></h3>

<?php the_excerpt(); ?>

<?php link_pages('Pages: ', '', 'number') ?>

<em>Posted by <strong><?php the_author() ?></strong></em>
Filed under: <?php the_category(',') ?>

<?php comments_popup_link('0 comments', '1 comment', '% comments') ?>

<?php comments_template(); ?>

<!-- // this is just the end of the motor - don't touch that line either :) -->
<?php endwhile; else: ?>
<?php _e('Sorry, no posts matched your criteria.'); ?>
<?php endif; ?>

bpat1434

WHy not just query each table and sort by date, and then print that which is the most recent?

Something like....

<?php
$tables = array('blog', 'news', 'something'){

foreach($tables as $table){
    $query = "SELECT * FROM `".$table."` ORDER BY date DESC";
    $result = mysql_query($query);
    if(!$result){
        echo 'No items to display.';
    }
    else{
        while($row = mysql_fetch_array($result)){
            echo $row['id'].'<br>'.$row['excerpt'].'<br>'.$row['linkpages'].'<br><br>';
        }
    }
}

?>

Why not do something like that?

~Brett

skipcollege

Hi Brett, forgive me as I don't actually know any php really. So if this would belong in the Newbies forum then a moderator is welcome to move it.

$tables = array('blog', 'news', 'something')

Here it seems as though this assumes that the different blogs are in the same database. They are in separate databases.

else{ 
        while($row = mysql_fetch_array($result)){ 
            echo $row['id'].'<br>'.$row['excerpt'].'<br>'.$row['linkpages'].'<br><br>'; 
        }

Here it seems as though these are fictitious examples of what to retrieve in the database?

The code I used is a modified version of the WordPress Loop from wp.php included with WordPress 1.5.2. Brett, what it seems like you are suggesting is to write some original php functions that access the databases and exactly what I want without involving WordPress' current code. That would be an option but I wouldn't know the php code to do it.

The first WordPress Loop is working perfectly but it just seems like something needs to be cleared for the next WordPress Loop which is currently outputting the same data from the first Loop. This seems like it would be the best way to accomplish this.

Any further thoughts?

bpat1434

Brett, what it seems like you are suggesting is to write some original php functions that access the databases and exactly what I want without involving WordPress' current code. That would be an option but I wouldn't know the php code to do it.

Wouldn't it be nice to learn, so that in the future you can then do something similar and not have to ask questions? It's the only way we get better....

I'm not sure. Maybe you're not closing the connection to the database, maybe your not really running the queries. I'm not familiar with wordpress (and I'd rather not be) so I can't say for certain.

What you can always do is start and end output buffering using the [man]ob_start/man and [man]ob_end_clean/man functions. You could throw those around the entire loop you want and see if it helps. I.e.

<?php
ob_start();
require_once('news/wp-blog-header.php');
?> 

<!-- blah blah blah blah blah -->

<?php
ob_end_clean();
ob_start();
require_once('journal/wp-blog-header.php');
?> 

<!-- blah blah blah blah blah -->

<?php endif;
ob_end_clean();
?>

~Brett