Hi guys, ive got an awkward problem that doesn't seem to want to fix itself no matter how hard i try.
Basically,
I have in my Database a table called horses and the columns are
I then have a php webpage with a dropdown box which is populated from the database.
<form action="" method="post" align="center">
<fieldset>
<select name="horses" onchange="benSucksDick(this.value)" align="center">
<option value="">Select a Horse</option><Br><br><br>
<!-- RUN QUERY TO POPULATE DROP DOWN -->
<?php
mysql_connect("localhost", "root", "") or die("Connection Failed");
mysql_select_db("horse")or die("Connection Failed");
$query = "SELECT * FROM horses ORDER by ID";
$result = mysql_query($query) or die(mysql_error());
/*$num = mysql_num_rows($result);*/
while($row = mysql_fetch_array($result)) {
echo "<option value='".$row['ID']."'>".$row['Name']."</option>";
}
?>
</select></fieldset>
I also have a AJAX call to edit.php which fetches the data in column web_horse and outputs it to a CKeditor instance.
AJAX code
<script type="text/javascript">
function benSucksDick(str)
{
if (str=="")
{
document.getElementById("maincontent").innerHTML="";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("maincontent").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","content/edit.php?q="+str,true);
xmlhttp.send();
}
</script>
edit.php Code
<?php
error_reporting(-1);
// Make sure you are using a correct path here.
include 'ckeditor/ckeditor.php';
$ckeditor = new CKEditor();
$ckeditor->basePath = '/ckeditor/';
$ckeditor->config['filebrowserBrowseUrl'] = '/ckfinder/ckfinder.html';
$ckeditor->config['filebrowserImageBrowseUrl'] = '/ckfinder/ckfinder.html?type=Images';
$ckeditor->config['filebrowserFlashBrowseUrl'] = '/ckfinder/ckfinder.html?type=Flash';
$ckeditor->config['filebrowserUploadUrl'] = '/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Files';
$ckeditor->config['filebrowserImageUploadUrl'] = '/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Images';
$ckeditor->config['filebrowserFlashUploadUrl'] = '/ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Flash';
mysql_connect("localhost", "root", "") or die("Connection Failed");
mysql_select_db("horse")or die("Connection Failed");
$q=$_GET["q"];
$sql="SELECT web_content FROM horses WHERE id = '".$q."'";
$resultab = mysql_query($sql);
while($row = mysql_fetch_array($resultab))
{
echo $row['web_content'];
}
?>
Now, the CKeditor initialises when the page is loaded, but when i change the dropdown to a different value from the database it just shows the html code and/or a text area WITHOUT the CKeditor instance.
If anyone can help me, that would be grand!!