edwardoit Posted February 18, 2008 Share Posted February 18, 2008 Guys question: How can i count this... example:.. colA ColB dog dog cat cat dog dog cat dog cat cat dog dog colA: dog: 3 cat: 3 colB dog:4 cat:2 can this be done using the mysql query alone? or with use of php? ur help is greatly appreciated guys... Thank u so much! Link to comment https://forums.phpfreaks.com/topic/91618-mysql-count/ Share on other sites More sharing options...
trq Posted February 18, 2008 Share Posted February 18, 2008 You'll need to use a few queries, but have a play aroudn with.... SELECT COUNT(colA) AS dogs WHERE colA = 'dog'; Link to comment https://forums.phpfreaks.com/topic/91618-mysql-count/#findComment-469268 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.