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! Quote Link to comment 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'; Quote Link to comment 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.