On my news site I’d like to make the address look something like this…

http://www.site.com/news/2004/08/05

And have the page only pull the entries for August 5, 2004.

How is this accomplished using php and mysql? Any ideas?