phppaper Posted December 1, 2010 Share Posted December 1, 2010 Dear all, I would like to find the total number of individual record in MySQL with php. For example: I have different department name stored in a column in MySQL. I would like to find out the total number of each department. But I do not know the names of the department How can I do it?? Counting the total of each department without knowing their names Thanks! Quote Link to comment https://forums.phpfreaks.com/topic/220310-find-the-total-number-of-individual-record-in-mysql-with-php/ Share on other sites More sharing options...
jcbones Posted December 1, 2010 Share Posted December 1, 2010 Well, we have no idea what you database tables look like, but it should be something like: $sql = "SELECT COUNT(id) as count, department FROM table GROUP BY department"; Quote Link to comment https://forums.phpfreaks.com/topic/220310-find-the-total-number-of-individual-record-in-mysql-with-php/#findComment-1141639 Share on other sites More sharing options...
phppaper Posted December 1, 2010 Author Share Posted December 1, 2010 But we do not know the name of the departments, your query shows that we already know the name, any thought? Quote Link to comment https://forums.phpfreaks.com/topic/220310-find-the-total-number-of-individual-record-in-mysql-with-php/#findComment-1141649 Share on other sites More sharing options...
jcbones Posted December 6, 2010 Share Posted December 6, 2010 You didn't even try it did you? Nowhere in that query does it say that we know the name of the department. It says: "Return the department name to me, and a count of how many times it exist in this table". Quote Link to comment https://forums.phpfreaks.com/topic/220310-find-the-total-number-of-individual-record-in-mysql-with-php/#findComment-1143458 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.