petenaylor Posted June 20, 2011 Share Posted June 20, 2011 Hi all I have an SQL table that looks like this: ID name date 1 Pete 20/06/2011 14.26 2 Steve 20/06/2011 13.25 3 Jon 20/06/2011 9.23 4 Pete 19/06/2011 5.56 Basically it is a log of when each user logs into a system I need to create an SQL query that will add up all the instances of each person and give a total. Many thanks for your help Pete Quote Link to comment https://forums.phpfreaks.com/topic/239876-count-num-of-rows-for-each-user/ Share on other sites More sharing options...
PFMaBiSmAd Posted June 20, 2011 Share Posted June 20, 2011 You would use GROUP BY name and use COUNT(*) to get a count of the number of rows in each group - http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_count Quote Link to comment https://forums.phpfreaks.com/topic/239876-count-num-of-rows-for-each-user/#findComment-1232146 Share on other sites More sharing options...
petenaylor Posted June 20, 2011 Author Share Posted June 20, 2011 That's great, thanks for you help. I am struggling to add this to PHP code. All I need to do is to echo out the name and the count. Thanks for your help Pete Quote Link to comment https://forums.phpfreaks.com/topic/239876-count-num-of-rows-for-each-user/#findComment-1232276 Share on other sites More sharing options...
Maq Posted June 20, 2011 Share Posted June 20, 2011 I am struggling to add this to PHP code. All I need to do is to echo out the name and the count. Post your code, then we can help. You can also look in the manual for some examples - mysqli_query. Quote Link to comment https://forums.phpfreaks.com/topic/239876-count-num-of-rows-for-each-user/#findComment-1232310 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.