dean
04-19-1999, 05:10 PM
I have a site that is 90% mySQL driven, from the voting booth, news, featured stories, news archive etc..
I update the site entirely from a from. Then as I add a news item, older items get move to archive, only the newest items get a graphic displayed with the news. Fully automated from the form and easy to maintain.
So when someone views the page there are multiple calls to the mySQL database before the page is displayed.
I was thinking, After I add a news item etc. I the script that updates the database would geneterate a text file. Then in my code instead of my 'include file show_news.php3' command, I would do a a include news.html that would be a pre-built html page. I think this would make the pages load faster. vs. making a bunch of mysql call each time a page is called.
1) is there an easy way to make a file and save the formatted results of a database search ?
I update the site entirely from a from. Then as I add a news item, older items get move to archive, only the newest items get a graphic displayed with the news. Fully automated from the form and easy to maintain.
So when someone views the page there are multiple calls to the mySQL database before the page is displayed.
I was thinking, After I add a news item etc. I the script that updates the database would geneterate a text file. Then in my code instead of my 'include file show_news.php3' command, I would do a a include news.html that would be a pre-built html page. I think this would make the pages load faster. vs. making a bunch of mysql call each time a page is called.
1) is there an easy way to make a file and save the formatted results of a database search ?