MySQL Data Formating For Product Catalogue
I am using DataAssist to create a product catalogue with pages generated in PHP and the data stored in schema tables with MySQL. I have two basic formating questions:
1. When storing text in MySQL datatype LONGTEXT for the ProdLongDecs, what is the best way to formate on display page? Do I simply include the CSS tags in the text that is stored in the database table column and then create and apply CSS styles for those tags? For example, I would like to inlcude subheadings and a list of bulleted items included with product under the main long text discription.
2. WebAssist dynamic sample site BlueSkyMusic uses the DECIMAL(19,0) datatype setting in MySQL for all monetary values. Is this for math calculation simplicity? Then do would again use CSS to format the value and control the decimal place to display as $0.00 in the catalogue?