Rich Text Editors and Retrieving SQL Data

[wispas]

I have built a content management system that manages my database (mysql) articles and am trying to use rich text areas instead of regular text areas. I have followed the tutorial:

http://www.dynamicdrive.com/dynamicindex16/richtexteditor/index.htm

Everything works. I can use the rich text editor to upload new content, but I was wondering if anyone knows how to retrieve the data from the database into the rich text areas when editing the content.

[djheru]

If you are using TinyMCE, I believe that it dynamically replaces a textarea element with the text editor. In that case, just save the db data to a variable, and insert that var in between the open and closing textarea tags. If you are using the object oriented method of generating your rich text editor on the page, I believe it has a method to set the default text. In the examples, they probably use a static string, but you can just replace that with the var you stored the db info in.