Question about automatically updating site content

[tylerj]

I am wondering if the following scenario is possible: I run a sports website and was wondering if I could have an "upcoming game" updated automatically through a schedule that I give it. So like if it says: "upcoming game: tues vs. Chicago" on wednesday, after this game has passed, it would change to the next date I have inputed. so on wednesday it would look like this: "upcoming game: friday vs Dallas." All of this without ever manually changing it. I would guess I would have to run some sort of program or script on my web server for this (cgi, ssi)????

Thank you for any help or links,

best regards,if any of this is confusing, email me at tylerj@austin.rr.com for explanation.

Tyler

[Jason]

Tylerj,

This sounds like something that can be easily accomplished with javascript. You might try posting in the Client Side Scripting category.

------------------
Jason M. DesRoches
Co-Founder / Business Development
Big Resources Network (http://www.bigresources.com)
jason@bigresources.com
ICQ: 17947522

[Pegasus]

Tyler, you'd have to update this one once a month, but it might work...

http://www.a1javascripts.com/dhtml/page_effects/scrollmessageofday/scrollmessageofday.html

If not, there are a whole slew of other scripts that would work. There's a pop-up calendar that's good for more years than I'd ever need. It's in a slightly different section, under "Time".

Peg

[kevin]

thread posted on: 10-08-2000

is this a case of better late than never? :D

[Pegasus]

Originally posted by kevin
thread posted on: 10-08-2000

is this a case of better late than never? :D <blush> Good grief, Kevin! I hadn't noticed! It was listed as being a new message. <sigh> Gotta learn to read, don't I?

Peg

[putts]

Why not just set up a database with a table that holds the team's schedule.

Then when the page loads you can query the table like this:
"SELECT GAME_NAME FROM TEAM_SCHEDULE WHERE GAME_DATE > " & today()

And then you just need to display the first record returned.

This way you only have to update your table once for the entire schedule.

It sounds like currently you are just using HTML, so I'd suggest learning some PHP and mySQL, but those are worth while to learn for anyone doing web development anyway.

[kevin]

Originally posted by putts
Why not just set up a database with a table that holds the team's schedule.

Then when the page loads you can query the table like this:
"SELECT GAME_NAME FROM TEAM_SCHEDULE WHERE GAME_DATE > " & today()

And then you just need to display the first record returned.

This way you only have to update your table once for the entire schedule.

It sounds like currently you are just using HTML, so I'd suggest learning some PHP and mySQL, but those are worth while to learn for anyone doing web development anyway.

hehehe.... this thread is 2 and half years old. I don't thinkl Tyler (2 posts total) gives a gosh darn anymore, hopefully he/she figured it out a log time ago. ;)