[Logician]

Originally Posted by Highlander

is there really no way about?
something like that:

PHP Code:

SELECT * FROM threads ..... LEFT JOIN attachment WHERE id= 


is this a way out?

You can not do that because attachments are not attached to the threads they are attached to the posts.

So the actual query should be
SELECT post.*, attachment.* FROM post LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid where ...
but this does not even help you altough it successfully returns relevant attachments per post.

It does not work, because after you get the attachment info with this query you need some PHP code to do to display the attachment correctly. They are permissions code, extensions code etc.

Edit functions.php and check the code after this line and you'll understand me better:

PHP Code:

if ($post[attachmentid]!=0 and $post[attachmentvisible]) { 


Bottom line you can not do it.