5 latest articles

[DiscussAnything]

I have the article hack (vb2) on my site, and wanted to include '5 latest articles' on the vbhome lite page. I can't seem to get it to work though, and was hoping someone could tell me what I'm missing.

This is the PHP I added to the index.php. Its based on the '10 latest threads':

PHP Code:

// +--------------------------------------------------------------
// | Latest KB Articles
// +--------------------------------------------------------------
$kbheader = '';
$kbbits = '';
{
  eval( '$kbheader = "' . gettemplate( 'home_kbheader' ) . '";' );

  $kbart = $DB_site->query("
    SELECT artid, categoryid,date, title, hits, author
    FROM vbArticles_content
    WHERE categoryid != 7 AND categoryid != 8 
    ORDER BY artid DESC LIMIT 5
  ");
  while ( $kbart = $DB_site->fetch_array( $kbart ) )
  {
      eval( '$kbbits .= "' . gettemplate( 'home_kbbit' ) . '";' );
  }
  $DB_site->free_result( $kbart );
  unset( $kbart );
} 


As you can tell this uses 2 templates, a header and a bit that displays the info for the article. The query works, I've tested it and it gives me the 5 latest additions, leaving out anything from category 7 or 8.

The index however only gives me the single latest addition, not 5. The kbbit template is:

PHP Code:

<tr class="clfirst">
<td><img src="{imageshome}/arrow.gif" alt="" class="imgborder" height="7" width="7" border="0"/><a href="$bburl/articles.php?action=viewarticle&artid=$kbart[artid]"><span class="txtbold">$kbart[title]</span></a><br />
Added: $kbart[date]<br>
Author: $kbart[author]</a><br>
Views: $kbart[hits]</td>
</tr> 


Nothing I can see that's wrong here. So why doesn't it display 5? The query works, the template works, but together it doesn't...

help?

[cinq]

what are the 2 opening brackets ( one just below kkbits=''; and the matching one at the end ) for ?

[DiscussAnything]

I'm not sure, but that's how the vbhomelite latest threads seem to work. I just copied that piece of code and changed the code to work with the articles

[DiscussAnything]

Turns out the latest threads had an IF statement there. So i removed those brackets and it still works, but still only 1 article, instead of 5

[Dean C]

Perhaps its because you only have one article which matches this criteria. Run the query in phpmyadmin to see how many results it returns.

Also do you have the $kbits variable in the home_kheader?

[cinq]

Ok just a shot in the dark, but try this for the php code:
Not too certain if it would help any though.

PHP Code:

// +-------------------------------------------------------------- 
// | Latest KB Articles 
// +-------------------------------------------------------------- 


  eval( '$kbheader = "' . gettemplate( 'home_kbheader' ) . '";' ); 

  $kbartquery = $DB_site->query(" 
    SELECT artid, categoryid,date, title, hits, author 
    FROM vbArticles_content 
    WHERE categoryid != 7 AND categoryid != 8 
    ORDER BY artid DESC LIMIT 5 
  "); 
if($DB_site->num_rows($kbartquery)) { 
  while ($kbart=$DB_site->fetch_array($kbartquery)) 
  { 
      eval( '$kbbits .= "' . gettemplate( 'home_kbbit' ) . '";' ); 
  } 
} 


Also if possible, post your kheader template ( though i don't think problem's there )

[Dean C]

Well I think the problem is if you have $kbits in the home_kbheader template. if so just move the:

PHP Code:

eval( '$kbheader = "' . gettemplate( 'home_kbheader' ) . '";' ); 


line to the bottom instead of top

[DiscussAnything]

5 - I owe you one, that worked perfectly! Shows once again that I should stay way from php code myself

Only way you could make me happier is if I could get my hands on the link directory with subsection code. I think i remember you mentioning you had that...


Dean, haven't tried your suggestion but I'm sure it'd work too, thanks

[Dean C]

Good luck with whatever you're coding

[cinq]

No problem, glad I could help