I have these tables. Users ( id,name,etc ) Coments : ( id , comment )
How do I do this kind of query:
I thought in one thing like this but I cant figure it out.
Example: Select * from users order by id desc in (select count (id) from
comments)
Expected result:
List of users:
* User1
See comments ( 32 comment in database )
* User2 See coments (13 comments in database )
You need to add a user_id column to comments, which records what user entered each comment. Then you can do
SELECT u.name, COUNT(c.id) FROM users u, comments c WHERE u.id=c.user_id GROUP BY (c.user_id)
The syntax may not be exactly right but that's the basic idea. Adding a user ID foreign key to the comments table is the important part.
Hope that helps, Larry
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
