Extract correct values from Mysql

mapg

I have a problem to extract values from Mysql

Taking this mysql table ...

Table name: access

id	ip		country		first_access
1	80.14.97.53	fr		2004-07-27 08:26:38
2	62.34.171.112	fr		2004-07-27 08:30:50
3	213.5.67.240	gr		2004-07-27 08:30:55
4	10.140.209.115	us		2004-07-28 08:31:42
5	217.126.113.147	es		2004-07-28 08:33:24
6	24.157.36.155	ca		2004-07-28 08:35:12
7	218.186.147.156	sg		2004-07-29 08:36:45
8	219.110.41.1	jp		2004-07-29 08:37:19
9	65.54.164.135	us		2004-07-29 08:37:50
10	67.15.35.8	us		2004-07-30 08:43:38
11	195.34.228.140	ru		2004-07-30 08:44:31
12	217.82.81.59	de		2004-07-30 08:55:16

... and with this PHP code ...

$access_avg_per_day = @mysql_query("select first_access from `access` group by date_format(first_access, '%Y-%m-%d') asc");
	while ($ctime = @mysql_fetch_array($access_avg_per_day)) {
		$time_data[] = $ctime['first_access'];
	}

echo print_r($time_data);

... I just get an array like that ...

Array ( [0] => 2004-07-27 08:26:38 [1] => 2004-07-28 08:31:42 [2] => 2004-07-29 08:36:45 [3] => 2004-07-30 08:43:38 )

Namely the first timestamp of everyday.

... BUT I would like to extract the set of timestamps per day and not the first timestamp only.

This case could summarized as ... "to extract dates and times stamps per day ... grouped just by date"

Any help is really welcome. Thank you in advance.

Mapg

mapg

A PHP programmer said me the response: A two-dimensional array.

$sql = "select first_access, date_format(first_access, '%Y-%m-%d') as date_day from `access` order by date_day asc"; 
$access_avg_per_day = mysql_query($sql) or trigger_error(mysql_error()); 
$time_data = array(); 
while ($ctime =  mysql_fetch_array($access_avg_per_day)) { 
        $day = $ctime['date_day']; 
        if(!isset($time_data[$day])) 
                 $time_data[$day] = array(); 
        $time_data[$day][] = $ctime['first_access']; 
} 
print_r($time_data);

And works!!. But what I see is that I am not used to handle a two-dimensional array. :-(

I do not know who start to organize the arrays in $time_data to separate arrays per day.

I have done several tests but with no success.

Sorry if I am so amateur in PHP programming. :-(

Any help is really welcome.

Mapg