count all member posts for each member

[jasonc]

i wish to get the total of posts from each member from the following database table

 

CREATE TABLE IF NOT EXISTS `posts` (
  `id` int(11) NOT NULL auto_increment,
  `submittedby` text NOT NULL,
  KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=786726 ;

 

i wish to have the results show the members name and the total posts.

 

how is this done please.

[asmith]

I assume the id field is referring to another table and the id means id post of that table?

 

table2 = the table which contains the posts

table1 = this table you showed us

 

SELECT t2.*, count(t1.submittedby) s numberOfPosts from TABLE2 as t2 INNER JOIN table1 as t1 ON t2.id = t1.id GROUP BY t1.submittedby