Update a static page if created before a certain time when someone requests the page?

I have a mysql driven site where the database is only updated twice each day. I am on a shared server and having 'db connection issues' when I get reasonable traffic.

So I would like to be able to create static versions of most of my pages but I would like a way to check if the static version was created before a certain time. If it was then to overwrite the static page with a new one.

I hope that makes sense. Basically I would like to automatically update my 'static' pages if they were created before a certain time when someone requests a page.

Any ideas?

Thanks.

 

PHP: filemtime() and then just use the math functions to compare against time() or date().

 

krsix: thanks for that. I have the time bit sorted now. So all I have to do now is create a new include file if the current one is too old. I think you have helped me find the solution. Thanks.

 

no prob mate, enjoy