You know, I did do something incorrectly. It doesn't update, I think I am using the wrong variables or something.
I want to select the latest posts in the forum but this returns the latest threads. Any help?
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
FROM thread LEFT JOIN forum ON thread.forumid= forum.forumid
WHERE thread.sticky=0 AND thread.visible=1
ORDER BY dateline DESC
LIMIT 10
and
Code:
<tr align="center">
<td class="$alternate" align="left" WIDTH="35%" VALIGN="TOP"><div class="smallfont"><a href='showthread.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>
Thanks in advance!