pull a post and post to forumhome?

[vietfancy]

Hi Guys!

I have one quick question. I want to pull the certain amount of words of a latest thread from a certain forum... and post to forumhome. How do i do that?

I can pull a last thread title from certain forum, and post to the forumhome by using this:
Code:

PHP Code:

$latesta = $db->query_first('SELECT title,threadid FROM ' . TABLE_PREFIX . 'thread WHERE 1 AND forumid = XX ORDER BY dateline DESC  LIMIT 1'); 
$lastnews = "<a href=\"showthread.php?"  . $vbulletin->session->vars['sessionurl'] . "t=$latesta[threadid]\">$latesta[title]</a>"; 


Now i want to pull the message of that thread and display on forumhome as well. Thanks.