Printing Variable value from mysql array

kmark

Hi,

I have a page where at the top of the page a variable is defined.

ex .
<?
$name = 'John Smith';
?>

In my mysql database I have a field which i want to print out the variable value. Right now the field in my database is -

Hi your name is $name

What I would like to know is what I need to type to get the database to print out 'John Smith' instead of '$name'

Thanks in advance

-Mark

acey99

Connect to your db :

$Connection=mysql_connect($Host, $Username, $Password) or die ("Unable to connect to MySQL");
mysql_select_db($Database) or die ("Unable to select database");

Query:

$sql=mysql_query("SELECT * FROM mytable"); # add WHERE CLAUSE IF NEEDED

$UserInfo=mysql_fetch_object($sql);

$UserInfo->name; # assuming NAME is a field in table.

leatherback

Hi Acey,

If I get you right, you would need to use the eval() function on the text from your database. That would force PhP to evaluate any scripting within that variable, if I am right.

kmark

Thanks it works great, I'm used to coldfusion and they have a similar thing I don't know hy i didn't think of it.

here is the final code for any one interested

$string = $array['c_text'];

eval("\$string = \"$string\";");

print $string;