Here it its...

SELECT * ,(SELECT COUNT(*) FROM replys WHERE replys.thread_id = threads.thread_id) AS reply_count FROM threads, members WHERE threads.forum_id = " & Forum_ID & " AND members.member_id = threads.member_id"

As i guess you can tell, this is for a message board system.
My problem is i want to pull out the member name from my members table that relates to my threads table. But it keeps pulling the same person out!

Any ideas?