adding a sql retreived value to a ‘href’

Hey all,

I need to add a value which I am retrieving from a sql table to a ‘href’ link… if you check out my page, you’ll see exactly what I mean:

[url]www.paulclift.net/CC-MSM/trapani.php[/url]

On the right-hand side, under ‘Score:’ there are a bunch of links, which I am retrieving from a sql database. BUT I need to add the folder to the link for it to work. Here is the relevant section of the php code:

[COLOR=”DimGray”]

while($info = mysql_fetch_array( $data ))
{
Print ‘<tr height=”30px”> ‘;
Print ‘<td><a href=”media/?$info[score]”>’.$info[‘score’] . ‘</td></tr>’;
}

[/COLOR]

Does anyone know how to add this to the href address?

THANKS!

Also in #PHP _↴