troubleshooting Question

Store Rich Text in MySQL Table and display with HTML

Avatar of rpkhare
rpkhareFlag for India asked on
8 Comments2 Solutions5183 ViewsLast Modified:
I have given an Entry Form to the user to input values that are stored in a MySQL table. There is one column called "Project Details", wherein the user can input upto 200 characters and this column is of type "varchar".

Till here everything is fine. The problem starts when the project details contain a number of points that are to be listed on the HTML page as:

(1) .........
(2) .........
(3) .........

It is unsure whether the project details is of one line, one paragraph, a simple text or a numbered list.

Is there any way to save the project details in rich text format in the MySQL table and when PHP shows the page of my website, the text gets listed as it was pasted?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros