Quote:
|
Originally Posted by tnguy3n
Assuming you'd put this code bit in forumdisplay.php file.
PHP Code:
SELECT forum.forumid, forum.title AS forumtitle, thread.*, post.*
FROM " . TABLE_PREFIX . " thread AS thread
LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN " . TABLE_PREFIX . "post AS post ON(thread.lastpost = post.postid)
WHERE thread.forumid = '" . intval($forumid) . "'
AND thread.visible = 1
ORDER BY forumtitle
LIMIT 0, 3
|
The code above will not work.
I'm not putting it into the forumdisplay.php file, I'm putting it into the query box with Logician's hack:
WebTemplates 3.x: VB Integrated Content Management System
Link to my question (and some ideas I have tried) in that thread.
https://vborg.vbsupport.ru/showthrea...267#post641267
I've also tried using the ORDER BY query option but no luck.
Thanks for the try anyway.
Any other ideas?
04-15-2005, 10:50 PM
Hybrid Mode
