Attachment SQL Query

[MrD3SAi]

Currently I have a query to get the attachments for a specific post:

PHP Code:

mysql_query("SELECT attachment.attachmentid AS attachmentid, covertype.type AS type FROM attachment LEFT JOIN covertype ON attachment.covertype = covertype.typeid WHERE attachment.postid = " . $threadinfo['firstpostid'] . " AND attachment.covertype != 0 ORDER BY attachment.covertype ASC") or die(mysql_error()); 


This works great; however, if I merge two posts and each post has attachment(s) it doesn't pull the attachment for the second post because

PHP Code:

WHERE attachment.postid = " . $threadinfo['firstpostid'] . 


Is there a way I can do a query based on all the post in the thread so it gets all the attachments for all the posts, not just the first one?

[Boofo]

$threadinfo['postid'] maybe?

[MrD3SAi]

UPDATE: I got it work using the following query:

PHP Code:

mysql_query("SELECT attachment.attachmentid AS attachmentid, covertype.type AS type FROM attachment LEFT JOIN covertype ON attachment.covertype = covertype.typeid WHERE attachment.postid IN (SELECT postid FROM post WHERE threadid = " . $threadinfo['threadid'] . ") AND attachment.covertype != 0 ORDER BY attachment.covertype ASC") or die(mysql_error()); 


[Boofo]

My answer was just a guess. A wrong one it seems now.