Create links from database data

Howdo All

Fairly new to php, and the site I am doing is for mobile use.

Anyway I have all the static pages written in WML and they all work fine, now I want to access the SQL database I have and get some info.

The query reads a team name and a team no and will generate links to another page whihc will display data depending on the team no and I need to pass this data along in the link. I know the links is something like sitepage.com?team=’teamno’ but as the data is coming from a database I need the link to be something like : sitepage.com?team=.$RS[‘teamno’] but cant get this working.

This is the code I am using up till now :

[code=php]<p align=”center”>
<?php
while($RS = mssql_fetch_array($result))
{
echo ‘<a href=”teaminfo.php#Info”>’.$RS[‘name’].'</a><br/>’;
}
?>
</p>[/code]

Any help would be appreciated,

Graeme

Also in #PHP _↴