help with dates and mysql

[Anon]

I'm writing some custom weblog code for a community site. I want to be able to display a heading (ie. "Sunday, March 31st") and then under that have entries for the times that posts were added. I'd like to list the last 10 days of entries, but the problem is that on some days there's not entries and others there's multiple entries.

Is there a way in MySQL to select from a DATETIME column the last 10 unique days? After that, how would I select rows that were posted on a specific day?

These are probably dumb questions but I can't find any good examples for things like this. Can anyone help out or point me to some good documentation on dates and MySQL?

[Anon]

select ... from ... group by LEFT(TimeStamp,8) limit 10

[Anon]

I think you'd have to add a DISTINCT to that query, otherwise you'd get the same date multiple times.

SELECT DISTINCT date FROM table GROUP BY LEFT(date, 8) LIMIT 10