How do you do this :: memberlist

fr600

for example: http://phpbuilder.com/board/memberlist.php

How is it done? I mean it selects members name from one table and no of posts from another table and combine the posts and name, shows all users and total post by each of them. I've been trying this, but I couldn't do that, everytime something goes wrong. Can anyone help me?

Gasolene

prob something like this...

SELECT *,COUNT(posts) as CountOfPosts
FROM posts
INNER JOIN user ON posts.uid = user.uid
GROUP BY user.uid

fr600

Gasolene wrote:

prob something like this...

SELECT *,COUNT(posts) as CountOfPosts
FROM posts
INNER JOIN user ON posts.uid = user.uid
GROUP BY user.uid

I've tried that but that's not all. More things are need to be done here.

Gasolene

I'm not sure what you'r asking.

fr600

Gasolene wrote:
I'm not sure what you'r asking.

Lets say there r two tables, users and topics.

User1 = 5 topics posted
user2 = 12
user3 = 1
user4 = 10
user5 = 34
user6 = 0
user7 = 33

All topics are inserted into topics table along with userid. Number of posts posted by users does not exist in users table. I need codes to select top 5 posters from users and their no. posts from tables and display that.

so in this case, it should display like this:
user5 = 34 topics
user7 = 33
user2 = 12
user4 = 10
User1 = 5

Any idea?

tunage

order by CountOfPosts

Gasolene

SELECT *,COUNT(posts) as CountOfPosts
FROM posts
INNER JOIN user ON posts.uid = user.uid
GROUP BY user.uid
ORDER BY CountOfPosts ASC
LIMIT 5

...assuming you use mysql

are you asking for the sql query, or help with the php code to display the returned data?

fr600

Ok, I'll post the code in the coding forum.