View Single Post
  #22  
Old 10-05-2006, 05:16 AM
trana's Avatar
trana trana is offline
Senior Member
 
Join Date: Sep 2005
Posts: 225
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Can you help me get the code straightened out for displaying the header image next to the title?

I see you have this:

Code:
$results = $db->query_read("SELECT t.title, t.views, t.replycount, t.threadid FROM " . TABLE_PREFIX . "thread t WHERE t.visible=1 " . ($forumid ? " AND t.forumid in (-1$forumid) " : "") . "AND t.postuserid = $userinfo[userid] $orderby LIMIT " . (intval($limit) ? $limit : "5"));


        $bits = "";
        while ($result = $db->fetch_array($results))
        {
            $bits .= "<div class=\"smallfont\">
			    <a href='showthread.php?t=$result[threadid]' title='$result[title]'>$result[title]</a></div>";
	}
        if ($bits)
        {
            eval('$GARS_addon_member_top .="' . fetch_template('GARS_addon_member_top') . '";');
        }
Do I need to do a separate SELECT to load the header images from the gars table or can it all be included on the one $results?

Thanks.
Reply With Quote