I need to call a url using php variables stored inside a mysql table column. For example:

In Mysql:

```
Table name:  geturldata
columns:    srno |  url
contents:   1 | http://www.google.com/number=$mobno&user=$username

```

Now, in php, i'll call this table like:

```
include (db.php)... 

$mobno = 91123456789;
$username = 'HELLOWORLD';

$QRY = "Select * from TBLNAME where srno=1";
$doqry = mysql_query($QRY);
$res = mysql_fetch_array($doqry);

echo $result_url = $res['url']

```

It shows:

```
 http://www.google.com/number=$mobno&user=$username

```

I want it to show:

```
http://www.google.com/number=91123456789&user='HELLOWORLD'

```

What should I change in MySQL table to get the above result?