Generate a link from data from my db?

I looked at a lot of examples but this one is not exactly covered in any of them. I want php to generate a line like this: <a href= "mynextpage.php3?id=3">Pedersgata nr. 5<\a> The input are to be retrieved from a database. I have a table from which I may retrieve records like this: $myrow6 = mysql_fetch_array($result6) $myrow6 have the data like the following 3 elements: id=3 gate=Pedersgata gatenr=5 so now I have $myrow6["id"] $myrow6["gate"] $myrow6["gatenr"] The problem is that I want to retrive and generate links to another page where the id is used. I want to use the retrieved records to generate a hypertext link consisting of a mixture of text and retrieved elements from the db, something like this: <a href= "mynextpage.php3?id=3">Pedersgata nr. 5<\a> And the text shown om my page skould be combined from $myrow6["gate"] nr. $myrow6["gatenr"] Does anyone know how to generate that line? -- Knut Lekvam __________________________________________________________________ Denne eposten er sendt ved hjelp av http://www.Organizer.net - Norges ledende webbaserte kommunikasjonsløsning.