Counting number of rows based on row name

Maller

Hey I have a small issue with counting number of rows based on the row name, currently I use this query

$query = mysql_query("SELECT usermail FROM invites WHERE invitename = 'joost'");
$pending = mysql_num_rows($query);

But I have like 8 different invite names, which equals 8 different queries.
So my question is if there is some way that I can turn those 8 queries in to one, and still get the number of rows for each name ?
Thanks in advance

NogDog

If you just want a count:

$inviteNames = array('joost', 'foo', 'bar');
$sql = sprintf("SELECT COUNT(*) FROM invites WHERE invitename IN('%s')",
               implode("','", $inviteNames));
$result = mysql_query($sql) or die(mysql_error());
$pending = mysql_result($result, 0);

Maller

It's still returns the total number of rows in the database.
Etc . I have 3 rows, with an email and a invite name, two requested foo and one bar

email - bar
email - foo
email - foo

I want to count how many time foo is in the database and how many times bar is, and so on.

NogDog

I'm hesitant to try another specific solution, as you've confused me a bit as to what exactly you want to appear in the results; but basically you're looking at a GROUP BY clause, I think. Something like...

SELECT invitename, COUNT(*) AS num_invites FROM invites GROUP BY invitename