Showing columns

[Jon12345]

I have this query:

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

How do I display the kid and count(action) column?

Is it like this?

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

Thanks,

Jon

[craygo]

well you have to do more than that
[code]<?php
$sql = "SELECT kid, count(action) AS count
from visitor_log
group by kid";
$res = mysql_query($sql) or die (mysql_error());
while($row= mysql_fetch_assoc($res)){
  echo "<tr>
        <td>".$row['kid']."</td>
        <td>".$row['count']."</td>
      </tr>";
}
?>[/code]

Ray

[Jon12345]

That solved it for me. Thank you! I didn't have count(action) AS count.

[Jon12345]

How would I modify the query string so that not only does it group by kid, but I also have a column that shows the number of kids that were grouped, if that makes sense.

Any ideas how?