Newbie needs some help - Webmaster Forums - Webmaster forum for HTML, PHP, ASP, CSS and more

jonnyw6969 · 08-12-2006, 12:20 PM

Hi all,

Please could someone help me with this situation?
Ok here's my problem, Im using a text editor called Fckeditor and using this to store the page information in a mysql database which im later calling it the main pages. The editor seems to work fine and is storing the information in the table.
The information it stores is stored as followed

 appears to have forgiven the Frenchman. 

I believe this is so it can be inserted into a php section but im not really sure.

When it gets echoed into the page it displays as above so none of the styles work.

Can anyone please shed some light onto this for me please?

No0oB · 08-12-2006, 12:38 PM

The escaping is correct, but you only have to escape when its in a string such as between " and "
So it would be

PHP Code:


		
			
$string = "<p align=\"center\"><br /><font color=\"#ff0000\" face=\"Arial\" size=\"4\"><strong>appears to have forgiven the Frenchman.</strong></font></p><br /><br /><br />";

I also corrected it a bit

jonnyw6969 · 08-12-2006, 12:43 PM

Ok great that makes sense

At the moment im using the code below to call it

<?php
$sql_page=mysql_query("SELECT * FROM `cms_page` where page_name='home'");
$res_page=mysql_fetch_array($sql_page);
?>

then

<?=$res_page['description']?>

what would i need to change there?

jonnyw6969 · 08-12-2006, 12:44 PM

didnt mean to sound sarcastic then, i really do appreciate any help

No0oB · 08-12-2006, 09:28 PM

I actually dont see any connection between the first post, and your request afterwards.
The mysql request doesnt have anything to do with that string

PHP Code:


		
			
<?
$sql = "SELECT * FROM cms_page WHERE page_name = 'home'";
$query = mysql_query($sql);
// if theres only one description
$row = mysql_fetch_array($query);
echo $row['description'];
// if there are more than one
while ($row = mysql_fetch_array($query))
   {
   echo $row['description'];
   }

I dont see any problem, why you would have to change your code.
I just pasted my code, so you see how I do it.
I think its a bit more structured