Question about query syntax

[Robert Basil]

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?