KrisP
03-03-2007, 07:59 PM
I need to ad (forum) title from the forum table to the query below......Can anybody help me to do it...
(Its a mod of latest threads on forum home. Take a look at the attached picture then you can see what I will use it for)
SELECT thread.*,thread.iconid AS threadiconid $previewfield, thread.lastposter AS lastposter
FROM ".TABLE_PREFIX."thread AS thread
LEFT JOIN ".TABLE_PREFIX."deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
$previewjoin
WHERE open <> 10
AND forumid NOT IN (0$limitfids)
AND forumid NOT IN (69,22,75)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost
DESC LIMIT 15");
I was also thinking of statusicons, but it is probably too complex...
(Its a mod of latest threads on forum home. Take a look at the attached picture then you can see what I will use it for)
SELECT thread.*,thread.iconid AS threadiconid $previewfield, thread.lastposter AS lastposter
FROM ".TABLE_PREFIX."thread AS thread
LEFT JOIN ".TABLE_PREFIX."deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')
$previewjoin
WHERE open <> 10
AND forumid NOT IN (0$limitfids)
AND forumid NOT IN (69,22,75)
AND thread.visible = '1'
AND deletionlog.primaryid IS NULL
ORDER BY lastpost
DESC LIMIT 15");
I was also thinking of statusicons, but it is probably too complex...