How to create HTML generator...using SQL databases?

If you would like to create a way to create dynamic websites in a structure then what you are looking to build is a web framework. I have been using Django, which works with Python lately, and it may be a little complex for you, but if you have a look at how the templates are filled by the code you write, you'll get a good idea of how something like this works. In the simplest way, you write an HTML template and even use something simple like PHP and includes to fill the page. Something like this: <h1><?php include $myheader; ?></h1> <img src="<?php include $myimage; ?>" alt="<?php include $myimage_alt ?>" /> and so on.

HTML is a programming language unto itself. Coding is generally the only way to get exactly what you want. The only other way to do this is use of WYSIWYG (what you see is what you get) editor. Providing a link to Amaya (the World Wide Web Consortium's editor) which is free to download and use.

I would say php is the way to go, especially if it's something simple. As far as mySQL goes I don't really see a need for using that as well unless you need to store the information entered outside of the generated pages. PHP is procedural not Object oriented as far as I know. FYI Jay Palsgaard: HTML is a markup language, not a programming language.