Mhtml
03-31-2003, 01:31 PM
Ok, right now on my forum I'm using 2 recordsets to do a lot of jobs, mainly because I forgot about joins and such lol :).
So I'm rewriting much of my code, now I've hit a wall.
Now on the first page it lists all the forums, firstly it lists the forums that are not in groups.
I can get the boards names and moderator name,
"SELECT *.Boards, *.Users FROM Boards, Users WHERE ModId.Boards = UserId.Users"
But I also need to count the number of posts for that forum where "BoardId.Posts = BoardId.Boards" How can I do that?
So I'm rewriting much of my code, now I've hit a wall.
Now on the first page it lists all the forums, firstly it lists the forums that are not in groups.
I can get the boards names and moderator name,
"SELECT *.Boards, *.Users FROM Boards, Users WHERE ModId.Boards = UserId.Users"
But I also need to count the number of posts for that forum where "BoardId.Posts = BoardId.Boards" How can I do that?