I wanting to input a report into a table named reports . The fields I am using are as followed:
id int(8) auto_increment unique
event varchar(30)
event_date varchar(10)
title text
subtitle text
author varchar(30)
report text
posted date
Question #1:
Once $report is submitted by the form, what would be the best way of formatting the large piece of text to recognize carriage returns, newlines, and other word processing formats like bold, italics, or event special characters.
Question #2:
What would the most efficient way of displaying the report, roughly.
Thanks for any help.