copying html page with mysql data in php

Question

I am trying to copy a file into a folder called profile. I got that working, but I need the page to be .html. I also need data from MySQL to put in the .html page. How do I go about that?

Answer 1

You can 'fake it' being a .html file using .htaccess:

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

Answer 2

Create a php file which loads the html file and then inserts data from mysql before outputting the results.