•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 361,619 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,190 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser:
Views: 381 | Replies: 3 | Solved
 |
•
•
Join Date: Feb 2008
Posts: 259
Reputation: 
Rep Power: 1
Solved Threads: 0
Posting Whiz in Training
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
the page this code should be updating does not have any sql or connection to a db on it so i have entered
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.
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.
Last edited by peter_budo : Mar 22nd, 2008 at 11:41 am. Reason: Keep It Organized - please use [code] for multiple lines not [icode]
•
•
Join Date: Sep 2007
Location: North Bay Ontario
Posts: 172
Reputation:
Rep Power: 1
Solved Threads: 20
Junior Poster
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
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'?
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'?
Last edited by trudge : Mar 22nd, 2008 at 5:26 pm.
Amer Neely - Web Mechanic
"Others make web sites. We make web sites work!"
"Others make web sites. We make web sites work!"
•
•
Join Date: Feb 2008
Posts: 259
Reputation:
Rep Power: 1
Solved Threads: 0
Posting Whiz in Training
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
•
•
Join Date: Sep 2007
Location: North Bay Ontario
Posts: 172
Reputation:
Rep Power: 1
Solved Threads: 20
Junior Poster
•
•
•
•
Originally Posted by kevin wood 
... 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.
Amer Neely - Web Mechanic
"Others make web sites. We make web sites work!"
"Others make web sites. We make web sites work!"
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
Linear Mode
Other Threads in the MySQL Forum
- Previous Thread: MySQL syntax error 1064
- Next Thread: sql "insert into" question
