PHP in MySQL?

[AlexC]

Hi,

i am templating a site, and have aproblem.

in mysql, i have stored the way an article should be displayed, however instead of the name (for example "Hello World!")displays $title

anyhelp appreciated

[petesmc]

Hi,

Could you show us with some code?

THanks

[AlexC]

function get_template($template_name) {
    $gettemplate = mysql_query("SELECT * FROM templates WHERE template_name='$template_name'");
    while ( $row = mysql_fetch_array($gettemplate)) {
        $templatehtml = $row["code"];
    echo("$templatehtml");
    }
} 

next

get_template("forumhome_usersonline"); 

which then produces

there are $usersonline online users right now

(and in the database, the code is

there are $useronline online users right now

Alex

[petesmc]

You'll have to do a str_replace on the variable as php code in a database is not parsed.

So either str_replace or you must eval() the code.