Content management problem... any ideas?

[Alexhoward]

Good evening!

 

I've created a content mangement system for my website.

 

This allows me to change all the text from the backend using a rich text editor.

 

The code inserts the formatted text into a MySQL table with all the HTML tags,

 

I then echo this on the front end.

 

Problem is, on some pages i need to use data either posted from a form, or pulled from a different table. i.e. a name attached to the users login via email.

 

so to pull out the content i'm using:

 

simplfied...

<?php

$con = mysql_connect($host, $db, $pass) or die ("Apologies we are experiencing technical difficulties") ;

mysql_select_db($db) or die ("Apologies we are experiencing technical difficulties") ;
		   
$query = mysql_query("SELECT * FROM table WHERE page = x") ;

while($row = mysql_fetch_array($query, MYSQL_ASSOC)) {

$content = $row['text'] ;

}

echo $content ; 

?>

 

however if i was echoing this manually i might put:

<?php

echo "Hello ".$full_name.", Welcome to my website..." ;

?>

 

So my question is... is there a way to input variables into the rich text editor so that they display a result on the front end..?

 

Thanks in advance!

[herghost]

Why dont you store this type of data in a session? then to call it you can just echo that session

[Alexhoward]

Hi, thanks for the reply.

 

Well...

 

I'm actually pulling a bit of data.

 

page title, description, keywords, etc...

 

but i can't echo anything... it will just output as text