[pierians]

Ok i got it.

Because my Sql is rusty could you please provide me the correct code?

--------------- Added [DATE]1245698588[/DATE] at [TIME]1245698588[/TIME] ---------------

Ok i made it

$query = $vbulletin->db->query_read("
		SELECT a.attachmentid, a.userid, p.username, a.dateline, a.filename, a.filesize, a.counter, p.postid, p.pagetext, t.threadid, t.title, f.title
    FROM " . TABLE_PREFIX . "attachment AS a
    LEFT JOIN " . TABLE_PREFIX . "post AS p ON (a.postid = p.postid)
    LEFT JOIN " . TABLE_PREFIX . "thread AS t ON (p.threadid = t.threadid)
    LEFT JOIN " . TABLE_PREFIX . "forum AS f ON (f.forumid = t.forumid)
    WHERE a.thumbnail_filesize > '0' 
    AND t.forumid  = '" . $foruminfo['forumid'] . "'
		$order");
		$thumbnails = ''; 
		while($i < $max && $rows = $db->fetch_array($query))
		{
			if($foruminfo['forumid'])
			{
				  $i++;
					$array[$i][attachmentid] = $rows['attachmentid'];
					$array[$i][postid] = $rows['postid'];
					$array[$i][thumbnail] = $rows['thumbnail'];
					$array[$i][dateline] = $rows['dateline'];
					$array[$i][filename] = $rows['filename'];
					$array[$i][filesize] = $rows['filesize'];
					$array[$i][userid] = $rows['userid'];
					$array[$i][username] = $rows['username'];
                                        $array[$i][title] = $rows['title'];
                                        //$array[$i][title] = $rows['title'];
			}

But there is already a variable called title...(that's why i made it comment)
How can i use it?