FCK 1.6 - editor data from mysql

Hi everyone, I've installed FCK 1.6 and am able to insert editor changes, via php, to a mysql database. But when I refresh/re-call the FCK editor i get the following:

this is a <A href="http://www.test.com" target=_parent>test </A> how about bold

this is using the javascript version. I've also tried the php verison and get the same results. Any Ideas?

here is my code in the javascript version:

                <?php
                    $gid=$_SESSION['gid'];
                    $sql="select test from testing where id=$id";
                    $result = mysql_query($sql);//send query to the db
                    
                    $row = mysql_fetch_array($result);
                    $mission=$row[0];
                    //echo $mission;
                ?>

Thu, 07/22/2004 - 13:38

vark

Joined: 22/07/2004

Posts: 3

RE: FCK 1.6 - editor data from mysql

a piece of the javascript code that I previously posted was commented out for testing that didnt' help...heres what that piece thats giving me problems:

//oFCKeditor.Value = 'this is a <A href="http://google.com"; target=_blank>test </A> how about bold' ;

                        <?php
                            echo "oFCKeditor.Value = '$mission' ;";
                        ?>

Thu, 07/22/2004 - 16:26

vark

Joined: 22/07/2004

Posts: 3

RE: FCK 1.6 - editor data from mysql

I figured out my problem. I was inserting the the html into mysql using the htmlentities() function. After inserting straight html everything was fine.