Need Recommendations

How to handle look ups?

[customdy]

When I designed our site over a year ago I knew nothing about web design (still don't know that much).

The site is 100% static, we have about 200 products and all pricing is hardcoded to the 100 html pages. This makes
price changes a major problem.

I want to add some type of database or lookup so that we can easily make price changes in one spot and not in all 100+ html pages.

I have considered a mysql database and php but not totally thrilled to remane the 100+ pages from .htm to .php, do the re-directs, etc. The 100+ pages have good PR and rank high in the SERPs (wish our index page did - Florida too care that but that is another subject)

Any suggestions? Is is possible to make a new html page with all of the prices and pass these variables to the other pages?

Thanks

[Dreamquick]

Not my area of expertise but I'm pretty sure you can use .htaccess to map the .htm filetype to be processed/parsed as a PHP filetype - that saves you needing to rename to get access to PHP functionality which just leaves you with the hassle of doing some database feeds for those pages.

- Tony

[customdy]

Thanks, I will look more into the .htaccess

[div01]

It should be something to the effect: (please test first)

RemoveHandler .html .htm
AddType application/x-httpd-php .php .htm .html