Displaying latest post per forum in other pages than forumhome

[Itsuki Minami]

ok i was completely redoing my site and i got and idea well is something i have saw here, i want to display latest thread per forum like these look

Manga Fox: Liar Game Manga Series

And well that's the problem D: i know it must be a query i can do or something but well have you seen the video-directory? let's say i created a category named news and i got a subforum named news, in the video directory category i want to display the latest post of the news subforum D: that's exactly what i want to do xDU i have been thinking all day and nothing came up so any suggestions/ideas?

 

[Itsuki Minami]

xDU so i got to bump I'm learning php and mysql so i got a little advance in what i want to make first I modified the video_category table so you can input the forumid that you will use for the query to make, next i wrote the query xD like these

   	[COLOR=#000000] [COLOR=#0000BB]
$ultimosthreads [/COLOR][color=#007700]= [/color][color=#0000BB]$db[/color][color=#007700]->[/color][color=#0000BB]query_read[/color][color=#007700]([/color][COLOR=#DD0000]" 
SELECT threadid,title,postusername,postuserid,dateline  
FROM " [/COLOR][color=#007700]. [/color][color=#0000BB]TABLE_PREFIX [/color][color=#007700]. [/color][COLOR=#DD0000]"thread 
WHERE forumid = $catinfo[foroid] ORDER BY dateline DESC LIMIT 10"[/COLOR][color=#007700]);  [/color][/COLOR]

so now i got to make the Fetch Array While Loop xD and i did it but (ok here comes the problem) when i call to the variable for the loop lets say i made the loop like these

    while ($ultimosthread = $db->fetch_array($ultimosthreads))
    {
        $titlethread =  $ultimosthread['title'] 
        $poster =  $ultimosthread['lastposter'] 
    }

so i only got to do the table right? with the titlethread and the other stuff the problem i got is it only displays one item D: and i don't know what to do next xD maybe my array is all messed up xD so can someone please xD help me this time xDU