Count different words in MYSQL db

Anon

I have a my SLQ database that looks like this:

COLUM1 COLUM2

Now, I would like to count the number of times yes, maybe and no aprear in the colum. When I use the code here he only counts the "yes" word, so, this gives me a 3. Thats fine but I also need 2 other outputs, a 1 for the no and a 2 for the maybe-word. Can anyone help me out please?

$query = "SELECT colum2, COUNT(*) AS number FROM will GROUP BY colum2";
$result = mysql_query($query);
$obj = mysql_fetch_object($result);
echo "$obj->number";

Anon

You're SQL statement is fine. If you echo mysql_num_rows($result), you will find that you have three rows (one for each word - yes, no, maybe).

Try this...

$query = "SELECT colum2, COUNT(*) AS number FROM will GROUP BY colum2";
$result = mysql_query($query);
while ($row=mysql_fetch_row($result))
{
echo $row[0];

}

That should loop through all your rows and display each.

Have fun,
AaronZoller.com