Variables in database...

[Anon]

I am interested in being able to exchange variables within text that is taken directly from a database. For instance I would like to be able to write:

"To get hold of me, ring this $phone_number. Otherwise you can come directly to $address etc."

When I parse this, none of the variables is changed to phone numbers or addresses. It works if I write the string directly in the code. Is there a special function for this kind of behaviour, like htmlspecialchars etc ?

[Anon]

I think you are fetching $phone_number and $address from your database. You may have a lot of phone_numbers and addresses in the database. Hopefully, there should be some mechansim to identify the phone_number and address for which you are looking.

Ex:

Suppose there is a table named addresse containing fields like(ID, address, phone_number)

Every record is identified by ID.

$q = "select * from address where where_condition";
$r = mysql_query($q);
$d = mysql_fetch_object($r);

Now it is possible to incorporate text and data from your database:
"To get hold of me, ring this $d->phone_number. Otherwise you can come directly to $d->address etc."

The result which is returned by the above query should be one record.

Tamirat