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