script Posted March 7, 2006 Share Posted March 7, 2006 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 Quote Link to comment Share on other sites More sharing options...
script Posted March 8, 2006 Author Share Posted March 8, 2006 Does anyone have an answer for me? I noticed that my post was pushed down about 3 pages Quote Link to comment Share on other sites More sharing options...
kenrbnsn Posted March 8, 2006 Share Posted March 8, 2006 There are plenty of freeware PHP calendar systems out on the web.If you don't mind using Javascript there is a very nice free package on the Yahoo Developers Network. This package can be found at [a href=\"http://developer.yahoo.net/yui/calendar/index.html\" target=\"_blank\"]http://developer.yahoo.net/yui/calendar/index.html[/a]I've been playing with it, interfacing it with a MySql database. The results can be seen [a href=\"http://www.nnjsda.org/calendar_test/index3db.php\" target=\"_blank\"]here[/a]. The blue boxes indicate that at lease one event is schedule for that day.Ken Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.