Query ends after 1 loop

[Twilkey]

What about this code could cause only one row to be displayed?

I have tried this with $blogs = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "blog");
and there are over 1000 entries to display, so I am pretty sure the query is fine. I tried deleting the avatar code just to see if it helped, but when I go to save the plugin, I get a 301 error. So i can not even get rid of that code to test.

PHP Code:

$blogs = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "blog WHERE `state` = 3 ORDER BY dateline DESC LIMIT 0, 3");  
   
  while ($blog = $db->fetch_array($blogs))  
  { 
    $blog[blogid] = $blog['blogid'];  
    $blog[title] = substr($blog['title'], 0, 30) . '...'; 
    $blog[comments] = $blog['comments_visible'];  
    $blog[userid] = $blog['userid'];  
    $blog[username] = $blog['username']; 
    $blogdate = vbdate($vbulletin->options['dateformat'], $blog['dateline'], true); 

               //Avatar Display 
               $avatarurl1 = fetch_avatar_url($blog[userid]); 
                       if ($vbulletin->options['usefileavatar']) 
                       {                            
                           if ($avatarurl1) 
                           { 
                                 $avatarurl = $vbulletin->options['bburl'] . '/' . $vbulletin->options['avatarurl'] . '/avatar' . $blog[userid] . '_' . $blog[userid] . '.gif'; 
                           } 
                           else 
                           { 
                                 $avatarurl = $vbulletin->options['bburl'] . "/review/images/noavatar.gif"; 
                           }     
                       } 
                       else 
                       { 
                           if ($avatarurl1) 
                           { 
                                 $avatarurl = $vbulletin->options['bburl'] . '/image.php?u=' . $blog[userid]; 
                           } 
                           else 
                           { 
                                 $avatarurl = $vbulletin->options['bburl'] . "/review/images/noavatar.gif"; 
                           }                             
                       } 
        $blog_bits = vB_Template::create('news_blog_bit'); 
        $blog_bits->register('blogid', $blog[blogid]); 
        $blog_bits->register('blogtitle', $blog[title]); 
        $blog_bits->register('blogcomments', $blog[comments]); 
        $blog_bits->register('bloguserid', $blog[userid]); 
        $blog_bits->register('blogusername', $blog[username]); 
        $blog_bits->register('blogdate', $blogdate); 
        $blog_bits->register('avatarurl', $avatarurl); 
        $blog_bits .= $blog_bits->render();    
  } 


<li class="forumbit_nopost L2" id="catblogs">
    <div class="forumrow L2">
                    <a href="blog.php?b={vb:raw blogid}" target="_blank"><img src="review_sidebarimage.php?image={vb:raw avatarurl}" class="forumicon" border="0" /></a>
        <div class="forumdata">
<div class="datacontainer">
            <h2 class="forumtitle"><a href="blog.php?b={vb:raw blogid}" class="forumtitle">{vb:raw blogtitle}</a></h2>
            <p class="tcatDesc">
            Posted By: {vb:raw blogusername}<br />
            Posted On: {vb:raw blogdate}<br />
            Comments: {vb:raw blogcomments}</p>
        </div>
</div>
    </div>

</li>

[Boofo]

LIMIT 0, 3 is only going to give you the first 3 results from the database. And the end } should be after the while loop (before //Avatar Display), shouldn't it?

[Twilkey]

3 results is what I wanted, and as for the last }. Doing that would just cause the whole thing to stop working.

Either way, I figured out the problem. I used $blog_bits to create the template and register the variables, then I also used the same to store the render of the template. You can not do that. So I simply made

PHP Code:

$blog_bits .= $blog_bits->render();
into 
$blog_bit .= $blog_bits->render(); 


It was a simple mistake on my part.

Thanks for your input though Boofo.

[Boofo]

Glad you got it. I still don't see why you need the Avatar Display and the template render in the while loop. But that doesn't matter now that you have it working.