I'm doing a few upgrades to a hockey teams webpage. They use php and their sql database for news updates aswell as score updating. I was wanting to put a nice little calendar up on the main page of the current month, with away games in one colour and home games in another colour that would automatically update itself every month according to the game schedule table that I input.

I use phpmyadmin and I know that there is a little calendar incorporated as part of that, would I be able to use that?

my database is called a2307 and the table with the schedule is called schedule.

Just not sure exactly how I'd query out the fields that I want and have the output as just a nice little calendar. Also I was wanting to have the game days as links, already played games would go to my stats page and the upcomming games would go to a page with a listing of all upcomming games.

Any Suggestions?

-script