[Logician]

Originally Posted by Mark41

Sorry for the double post, but now I'm just confused. Can anybody make this? I'm nearly beside myself.

I'd like it to be four things. The name of the forum the post is in with a link to the forum (like it is on my homepage). The name of the thread linking to the newest post. The name of the poster linked to them. The date the latest post was made.

Currently on my front page, it lists it as the latest threads created, not posts made. Can anyone help with this?

PHP Code:

SELECT thread.threadid AS threadid, thread.title AS title, thread.postusername AS postusername, thread.postuserid AS postuserid, thread.dateline AS dateline, forum.title AS ftitle, thread.forumid
FROM " . TABLE_PREFIX . "thread thread LEFT JOIN " . TABLE_PREFIX . "forum forum ON thread.forumid= forum.forumid 
WHERE thread.sticky=0 AND thread.visible=1
ORDER BY dateline DESC
LIMIT 10 


PHP Code:

<tr align="center"> 
 <td class="$alternate" align="left" WIDTH="35%" VALIGN="TOP"><div class="smallfont"><a href='forumdisplay.php?$session[sessionurl]t=$WQfield[forumid]'>$WQfield[ftitle]</a></div></td>
 <td class="$alternate" align="left" WIDTH="35%" VALIGN="TOP"><div class="smallfont"><a href='showthread.php?$session[sessionurl]t=$WQfield[threadid]'>$WQfield[title]</a></div></td>
 <td class="$alternate" WIDTH="15%" VALIGN="TOP"><div class="smallfont"><a href='member.php?$session[sessionurl]u=$WQfield[postuserid]'>$WQfield[postusername]</a></div></td>
 <td class="$alternate" WIDTH="15%" VALIGN="TOP"><div style="font-size: 8pt; line-height: 10px;">$WQfield[dateline]</div></td>
</tr>