I asked a question concerning saving posted data out of the FCKeditor v.2.3.1 in the thread below:
http://www.phpfreaks....msg426288.html (Thanks to xyn, who was very helpful)
I got that problem solved, but now the editor only saves to the first row in the database.
Just to sum it up again:
The editor is passed the page ID from a page listing. Editor then loads the data using this query:
<?php mysql_connect("server URL", "user name", "password") or die ('I can?t connect to the database.') ; mysql_select_db("clientd_psp") ; $pagedid = $_GET['id']; $posted_id = $_POST['id']; $result = mysql_query("SELECT * FROM content_tbl WHERE page_id=$pagedid") ; $row = mysql_fetch_array($result) ; echo "<div style=\"font-size:18px;\">" . $row['name'] . "</div><br />" ; //$sBasePath = $_SERVER['PHP_SELF'] ; //$sBasePath = substr( $sBasePath, 0, strpos( $sBasePath, "_samples" ) ) ; $oFCKeditor = new FCKeditor('PSP_editor') ; $oFCKeditor->BasePath = '/psp/fckeditor/' ; $oFCKeditor->Value = $row['page_content'] ; $oFCKeditor->Height = '500' ; $oFCKeditor->Create() ; echo ("<input type='hidden' value='$pagedid' name='page_id_value' />") ; ?>
This part works flawlessly. The problem I have is that when posting it to this script:
<?php$host="server URL" ; $login="user name" ; $pwd="password" ; $db="clientd_psp" ; $conn = mysql_connect("$host", "$login", "$pwd") or die('SQL Error: '.mysql_error().'') ; mysql_select_db($db, $conn) ; mysql_query("UPDATE content_tbl SET page_content='".stripslashes($_POST['PSP_editor'])."' WHERE page_id='".$_POST['page_id_value']."'") ; ?>
This only works when page_id is 100(the very first row in the database) I have no idea whats going, and I am definately a php noob, so I am at a loss as to whats going on with it not working. Like I said, its a problem with every row except the first one. Does anyone have any experience in using this wysiwyg?