Hello everyone,

on my site there's a tip of the day for which I want to create an archive ordered by month. So the first page in the archive is displaying all the available months with their links to the tip's overview. So far, that's not the problem... here it comes:

Every single tip is stored in a mySQL table with its date. With PHP I want to query the DB for all tips of that selected month. However the date is in the format "yyyy-mm-dd" and I'm sure that mySQL (or PHP?) understands what there's written as its saved as a date cell.

Can you help?