Jump to content


Photo

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


  • Please log in to reply
1 reply to this topic

#1 Mateobus

Mateobus
  • Members
  • PipPipPip
  • Advanced Member
  • 95 posts

Posted 26 August 2006 - 08:06 PM

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.

#2 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 26 August 2006 - 09:01 PM

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
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users