i have once again been asked to fix some code on a website. this time the website is meant to have a content management system but once again the person who made the original website did not complete what he started.

the content management system side of it is using InnovaStudio wysiwyg html editor to edit the text on the pages. it looks good but the support and user guides for this may as well not exist they are that bad.

the code i need help with is as follows

// save content to db
if(isset($_POST["inpContent"])) 
	{
	
	$sContent=stripslashes($_POST['inpContent']); // remove slashes (/)	
	$sContent=ereg_replace("'","''",$sContent); // fix SQL
		
	$sql="UPDATE cms_core SET editorial='$sContent' WHERE id=$id";
	$query = mysql_query($sql);
	}
	
// load content
if(!$_GET["id"]){ $id = 1; }
$sql = "SELECT * FROM cms_core WHERE id=$id";
$query = mysql_query($sql);
$result = mysql_fetch_array($query);
$sContent = $result['editorial'];

?>

the page this code should be updating does not have any sql or connection to a db on it so i have entered

<?php
		if(!$_GET["id"]){ $id = 1; }
		$sql = "SELECT * FROM cms_core WHERE id=$id";
	        $query = mysql_query($sql);
		$result = mysql_fetch_array($query);
		$sContent = $result['editorial'];

	    ?>

the page is not displaying any of the edited text.

If any one has used innovastudio and could give me some help with using this then that would be great.

I'm confused. Are you asking for help with MySQL or an HTML editor called InnovaStudio?

We can only help you with MySQL questions here. With that in mind, you say that

does not have any sql or connection to a db on it

So if there is no connection to the database, how do you expect the query to execute? Or am I missing something here? Have you confirmed that you are logged in to the database? Can you access it remotely from the command line using 'mysql'?

the problem that i am experiencing is that the html editor is doing the editing side fine but it is then not updating the database with its new saved data so this cannot be recalled on to a different page. when i try to recall the data i have put if stsatement in it and it tells me that there is no data stored in the database. so i need the html editor to store the data into a database so i can recall it on to the new page

... so i need the html editor to store the data into a database so i can recall it on to the new page

Then you should be looking in the documentation for that editor, or posting your query in a forum for the same. There is no MySQL question here that I can see.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.