Entry/exit pages (mysql)

[wxdqz]

I have a table like (mysql):table(ID, URL, Date, IP )How can I find the most popular first/last URL viewed pr IP pr day.That is I have problems when I use the GROUP BY.Its easy to find the latest page viewed ever.SELECT URL FROM table ORDER BY Date ASC.If I try something like SELECT URL FROM table GROUP BY Date, IP ORDER BY Date ASCThe ORDER BY is done after the group by and I need to order before the group by so that I can get the last/first page pr user pr day.Any sugestions?