Count num of rows in mySQL

[petenaylor]

Hi all

 

I have an SQL table that looks like this:

 

ID    name    date

 

1      Pete      20/06/2011 14.26

2      Steve    20/06/2011 13.25

3      Jon        20/06/2011 9.23

4      Pete      19/06/2011 5.56

 

Basically it is a log of when each user logs into a system

 

I need to create an SQL query that will add up all the instances of each person and give a total.

 

Not sure of the code, but this is what I have so far:

 

$getlogs = mysql_query("SELECT *,COUNT (*) FROM `logs` GROUP BY name");
  while ($showlogs = mysql_fetch_array($getlogs)) { 
   $userid = $showlogs['id'];
                   $name = $showlogs['name'];
   $count = mysql_num_rows($getlogs);

                  echo $name;
                  echo $count;
  ?>

 

All I need to do is show the name and the total number of times they appear in the table.

 

Many thanks for your help

 

Pete

 

[TeNDoLLA]

SELECT name, COUNT(id) AS `total` FROM logs WHERE name LIKE 'Pete'

[EdwinPaul]

SELECT name, COUNT(id) AS `total` FROM logs WHERE name LIKE 'Pete'

 

SELECT name, COUNT(id) AS `total` FROM logs GROUP BY name