self-updating site

charm: opinionated designer -- yes!
charm: accomplished programmer -- not quite...

i have a site where the content changes daily. how can i develop content weeks in advance and have the site update itself daily while i lay on the beach somewhere?

beach...yeah right.

thanks!

charm... it would help if we could see the site.. :p


heheh...


Snore

the site exists only in my head right now!
i think i've explained what i am looking to do good enough.
any ideas?

Charm,

I think I found a Javascript (not server side) solution to your question. I'm gonna test it now.
only thing....
your visitors (if they choose to) can look in the source and see the next days content, unless you call a .js from the page. anyway, I'll let ya know tonight.

I think it's pretty simple.

You can make a (MySQL) database with tables with names like 06102001 (today), 06112001 (tomorrow) etc. and then you van use PHP to get the date. With the date you can get the correct content out of the database. Do you see what I mean?

Well, I've been involved with a site like this and don't use different tables for different dates, that's not a good idea!

But the easiest way would probably be a simple php site with a mysql-db as a base. Then you store all articles with a start date and an end date.

Then you extract the articles based on those dates using plain old SQL, something like "SELECT * FROM articles WHERE startdate > now() AND enddate < now()" or something similar.

It's a bit of work, but it's put to good use and you'll learn a lot.
Dan

Well, Charm, I'm gonna shoot ya an email via this forum and you can reply to it and I'll send you the javascript... it is running on an aquaintance of mine's site and was tested updateing automatically monthly....but it will do it daily too.

Correction, you have email turned off from this forum, sooo, drop me a message at [email]Chris@webregion.com[/email]

Try newspro... don't remember the url, but shouldn't be to hard to find. With newspro u can post news in advance and set the date and time u want it to be available on the site.