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 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 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 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. 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
Archived
This topic is now archived and is closed to further replies.