variables in database text

[nozom]

is there anyway i can hold a variable a mysql database field.

eg. this bit of text is in the database
"hello, this is the database text."

and i put in somehow.
"hello $name , This is the database text"

with $name refering to a pre-defined variable.

One way i can think of is to put in an odd string into the text, such as |THEVAR| and then replace the charset using str_replace()

any other ideas?

thanks,
hugh

[LordShryku]

That's exactly what I would do, and actually do on some of my sites. Kinda like the vbCode here.

/* You insert 
"Hello [user_name], text text blah";
verbatim,then when you pull it...
*/
$pulledText="Hello [user_name], text text blah";
$userName="Somebody";
$newText=str_replace("[user_name]",$userName,$pulledText);

[nozom]

so i'm barking up the right tree for once 🙂

cheers,
hugh