My site is currently made up of static pages, with product description pages that follow a similar theme, but are all different to a degree. I'm moving the site over to Coldfusion, and planning to use it with mySQL.
Currently product pages contain a mixture of paragraphs, ordered and unordered lists, in a variable order. From my limited knowledge of SQL so far, I was thinking that I could have one table that refers to components of the page stored in other tables. For example, the first item might be a paragraph, stored in a paragraphs table, then there might be a list, and all items of that list are in a list table, then another paragraph etc.
I remember learning basic programming years ago, and started to design my own sort routine, and started by having it look at the first character of each word, and working through sequentially. I later discovered that there was no need, you could simply ask if one word was bigger than another word, in it's entirety.
Similarly, I'm wondering if there is a simpler way of storing a product description in a database. The people editing the product descriptions are not familiar with HTML, so I didn't want to simply have description with HTML formatting in the database.
I'm just in the design phase at the moment, the first time I've used a relational database or Coldfusion, but I have read the mySQL Crash Course book by Ben Forta, and am working my way through the CFWACK books, but (so far no example quite fits what I'm trying to do).
Thanks for any help, any tips would be useful.