just me and php Posted February 19, 2007 Share Posted February 19, 2007 I search around but think im using wrong key words on internet what im looking for is how many times a name was posted to db in one table so i get and output of something like bob 300 times Quote Link to comment Share on other sites More sharing options...
hitman6003 Posted February 19, 2007 Share Posted February 19, 2007 SELECT name, COUNT(name) FROM tablename GROUP BY name Quote Link to comment Share on other sites More sharing options...
just me and php Posted February 19, 2007 Author Share Posted February 19, 2007 thanks i think that will do it Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.