HTMKAnyone know of a database app which stores records in html format on the web server and nt in a sql server. I have a specific need for this.

Or Does anyone have code that will take records from a Mysql database and copy each record to a seperate html page.
Anyone please help.

Any app can store records in either sql backend. Depending on what kind of data, you can store a whole page, or "chunks" like a ul block with a bunch of li children in a long text column. Or if it's a user list, you can use varchar columns to store "<li>CodingMaster</li>" ... but that's not terribly efficient, and could wind up being very difficult to update down the line.

You can do a lot of the basics with queries and views, along the lines of Select '<li>' + Username + '</li>' From Userlist to store the raw data, but use it as if it's stored with html. At least that works for the simpler stuff, like a list of whatever, images, things like that. Entire pages tend to work better in a table with an id and a long text field.

But if that really doesn't work, you can resort to php: try a for loop to display each field in a record, with it's name and it's value, in a definition list - dl / dt / dd - and then save the page that generates. You could even stuff that into your new database. Still, I think storing the data separately from the markup is going to pay off over time.

I guess your forum name completly belies your actual coding skill, in the way that SEO & expert/guru/[insert place name] does. and you are just learning about databases and how to construct and use them.
The first thing to learn is; Size is expensive in terms of disk space and retrieval times and anything you can do to reduce that will pay big dividends as systems grow.

Text fields in database tables are just that, text.
The text stored there can take any form the programmer/DBA needs, HTML, javascript or even just plain old boring text.

I prefer to store textual data to be represented as HTML in a "BBCode" form, that is in the same way that forums do by using markup tags/placeholders that are replaced by HTML code on display.
so

<span style="color:red;background-color:yellow;font-size:20px;">This is highlighted with red on yellow</span>

would be stored in the field as

[hl st="r;y;20px;"]This is highlighted with red on yellow[/hl]

Then the data is parsed and the markup replaced as the output is streamed to the user agent.

Saves space in the database and makes updating the look of the pages easy.

Creating static pages is not required. You just create a navigation system and one page handles everything just like forums, blogs, CMS systems etc do.

Thanks for your kind help.