CREATE TABLE `hits` (
`hit_id` int(11) NOT NULL auto_increment,
`hit_date` datetime NOT NULL,
`hit_ip` varchar(15) NOT NULL,
PRIMARY KEY (`hit_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;


I need all unique ip address datewise in descending order,
SELECT * FROM `hits` GROUP BY `hit_ip` ORDER BY `hit_date` DESC

expected,
hit_id hit_date hit_ip
3 2009-12-24 16:08:55 1.1.1.2
2 2009-12-22 16:08:38 1.1.1.1

i am getting,
hit_id hit_date hit_ip
3 2009-12-24 16:08:55 1.1.1.2
1 2009-12-21 16:07:54 1.1.1.1

if each ip address can have multiple dates, then "unique ... datewise" doesn't make sense

it ~is~ possible, however, to associate a single date with each ip address -- the earliest, the latest, or some other calculation

what did you have in mind for this?

I want to display ip addresses when they last visited. That's the reason i want all the unique ip address and the dates in ascending order.

I want to display ip addresses when they last visited. That's the reason i want all the unique ip address and the dates in ascending order.

I want to display ip addresses when they last visited. That's the reason i want all the unique ip address and the dates in ascending order.