Little Querie Help Plz

[colicab-d]

yeah im look for some help with putting together some basic code to do the following....

selecting all the posts via a forum id, then only showing the attachments in those posts

would this be poss via just a user doing something like page.php?forumid=2

if so plz help as im confident about writing ht rest of my script using templates etc via vb3, its just im stuck here

thnx again colicab

[Xenon]

erm, sorry, but i don't get exactly what you mean.

from the context i think you mean something like that:

[sql]SELECT postid
FROM post
LEFT join thread USING (threadid)
WHERE thread.forumid = 2[/sql]