Hi,
Im currently making a little list for my site that tells people what CDs the webmasters of the site bought this month. If your wondering i fell it gives a community feel and makes people feel more involved with us.
However now ive done this i would like to make a list that automatically puts the previous months in the list so that people can look back at how crazed about cd buying we really are. im not sure how to do this as the database has each CD in with the month at the end, so if i use a query such as "SELECT * FROM mydatabase WHERE month=$month" where month will be defined by a date();. I cant use this because one it will pull up all of this months cds when i only want it to pull up one of them and two it only pulls up this months.
So just to make sure i make sense. how would i make a list that says september october. Without creating another table but useing the one i have.
I hope this is clear as mud but its really hard to explain in words...
Thanks
