[how to] Proper query for threads

[msimonds]

I was wondering if someone could point me in the right direction. I am trying to build a query in vb that will display the latest thread with the post contents.

PHP Code:

$query =$vbulletin->db->query_read("SELECT title FROM thread ORDER BY dateline DESC LIMIT 10");
$i = -1;
$array = $vbulletin->db->fetch_array($query);
while ($array = $vbulletin->db->fetch_array($query))
{
$title = $array['title'];
echo "$title<br>";
$i++;
} 


this gets the latest 10 threads but I want to add the first post text with each thread!!!

Any help would be appreciated

Thanks in Advance

Mike