query help

[Lpspider]

Okay, what I'd like to do is query the database to output only unanswered threads from specific forums.

I'm sorry that i'm basically asking for help but I haven't worked with creating a query in quite a while.

Could anyone help me out? Thanks.

[Kirk Y]

Basic example:

SELECT threadid, title
FROM thread
WHERE replycount = 0 AND forumid IN (X,Y,Z)

[Lpspider]

Thank you. This helps very much. Would it be possible to somehow restrict the replies from the user who posted the original thread in counting for the replycount? So if the user posts a thread and replies to it twice, the results from the query will still be the same as replycount = 0, even though technically there were two replies (from the thread-posting user)?

[Kirk Y]

Try this:

SELECT threadid, title
FROM thread
WHERE (replycount = 0 OR postusername = lastposter) AND forumid IN (X,Y,Z)