Jump to content

Archived

This topic is now archived and is closed to further replies.

Mateobus

Converting Database info into static pages that update every so often.

Recommended Posts

I have a website that record various team records and conference standings, that I don't wan't to have to recompute every time someone requests a page. I also don't want to have columns in my table for wins losses etc, becuase if a game gets edited all of those columns will need to as well.  The best solution would be to have static pages that are computed every so often.  Does anyone know how to do this?  Thanks.

Share this post


Link to post
Share on other sites
well one way could be to make a php admin opage where you choose to calculate/update and then it deletes or archives the current file and then writes a new html file based on the data u give it. therefore you can output to .htm files and not have any querys run at all and update at your wish..

another way could be to run a query everytime a user accesses the page to check the creation date of the file and update when it is out of date..

Regards
Liam

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.