[RESOLVED] Simple SQL statement

Jon12345

I have the following variables:

KID, Action, SID.

I want to:

a) group by KID
b) for each KID, I want it to count the values in Action.
c) display action/kid

Is it something like this?

SELECT * FROM visitor_log GROUP BY KID count(Action)

Thanks,

Jon

j_70

You don't mention what you want to do with SID. I think you want

SELECT kid, count(action)
from visitor_log
group by kid

Jon12345

Ok, I have tried that. But now I'm a bit confused about how I would display the counted actions next to each grouped kid. What should I do here?

echo "<td>".$row['kid']."</td>"; 
echo "<td>".$row['count']."</td>";

Is that correct?

j_70

More likely to work is:

echo "<td>".$row[0]."</td>";
echo "<td>".$row[1]."</td>";

Jon12345

I got zero results using that.

bradgrafelman

Well, how are you retrieving the resulting rows? (HINT: Which function?) I like to use [man]mysql_fetch_assoc/man.

Also, if you're naming the output of MySQL functions in your SELECT column list, I would give them an alias name for easy reference:

SELECT kid, count(action) AS count
FROM visitor_log
GROUP BY kid

Declaring the alias 'count', you should be able to use the code snippet you posted above (assuming, of course, you're using the right MySQL function).

Jon12345

Adding the AS count did the trick. Thank you.