Most effecient way of doing this...

[ciaranmg]

I'm relatively new to PHP and mysql and I'm trying to find the most effecient way of getting around my problem.

I'm currently working on a site that will have different content everyday on the front page. i.e. the all the menus etc will stay the same but the main content in the center of the table will change.

My question is, do I write my php in the main page to query the database and generate the page every time it is viewed or do I write a script that generates the main page once a day??? If so how is this done???

Regards
Ciaran.

[jblallement]

Hi,

If you don't need realtime for the main content then generate the main content once a day. That way, users will load a static page instead of a dynamic one nd that's most efficient way to do.

To do this, write a PHP script that generate the page.
Then, use PHP executable to generate the page and schedule this task with cron ( on Unix ) or Windows scheduler and save the output in a file.

On Unix you could do:

php page.php > /document_root/maincontent.php

[sepodati]

Name it .html that way it'll be friendly to search engines, too...