[Mazinger]

This is a correct code for a plugin, but it still can't call for iconpath.

PHP Code:

$topthreads = $db->query_read("
     SELECT thread.threadid, thread.title, thread.iconid, icon.iconid, icon.iconpath
     FROM " . TABLE_PREFIX . "thread
     LEFT JOIN " . TABLE_PREFIX . "icon AS icon ON (icon.iconid = thread.iconid)
     ORDER BY threadid ASC LIMIT 5
     ");

while ($topthread = $db->fetch_array($topthreads))
{
$favo.="<a href='t$topthread[threadid].html'><img src='$topthread[iconpath]'>$topthread[title]</a>";
}