Print out mysql data for hit counter

[brandontran]

I am trying to display hits to website pages in a specific format. When a visitor views the page, the sessions are recorded in the database similar to this.

 

Example snippet from my mysql database table:

id - page - date

1, page1, 2009-10-07

2, page3, 2009-10-07

3, page2, 2009-10-07

4, page9, 2009-10-08

5, page5, 2009-10-08

 

I would like to print this table in which the dates are unique and the rows are counted for those unique dates.

 

So end result would be an array such as this:

Array

(

    [2009-10-07] => 3

    [2009-10-08] => 2

)

 

Here is what I came up with so far however it isn't totaling hits for the dates. Which is why I'm asking for some help. I have messed with this a great deal with only this progress. Any help is greatly appreciated.

 

<?php

require_once("config.php");

 

@mysql_connect(localhost,$db_user,$db_pass) or die("Unable to connect to database");

@mysql_select_db($db_name) or die( "Unable to select database");

 

$query = "SELECT date FROM views Order by id DESC LIMIT 0,20 ";

$result = mysql_query($query);

 

$data = array();

 

while($item=mysql_fetch_row($result))

    {

$date = $item[0];

$total = count($date);

$data[$date] = $total;

    }

 

print_r($data);

 

?>

[brandontran]

I solved it:  This was the catch line: print_r(array_count_values($data));

 

 

@mysql_connect(localhost,$db_user,$db_pass) or die("Unable to connect to database");
@mysql_select_db($db_name) or die( "Unable to select database"); 


$query = "SELECT date FROM views ORDER BY date ASC LIMIT 0,20";
$result = mysql_query($query);

while($row=mysql_fetch_array($result))
    {
$data[] = $row['date'];
    }

print_r(array_count_values($data));

 

Which prints out:

 

Array
(
    [2009-11-04] => 3
    [2009-11-05] => 1
    [2009-11-06] => 1
    [2009-11-09] => 15
)