creating links after a MySQL search

[Anon]

Hi folks, I'm a PHP newbie confused about creating dynamic links rendered after a MySQL query.

After the MySQL query I render a table:

<table>
<?php do { ?>
<tr>
<td><?php echo $row_Recordset1['company']; ?></td>
<td>
<?php echo $row_Recordset1['description']; ?></td> </tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>

It generates a table of companies and the associated descriptions.

My question is: how do I create a link of the form company.php that links off of the c'company' output...

thanks for any help.

[Anon]

Answered my own question: create a field in the database with the URL: company.php. Name the field 'link'...

<table>
<?php do { ?>
<tr>
<td><a href="<?php echo $row_Recordset1['link']; ?>">
<?php echo $row_Recordset1['company']; ?></a></td>
<td>
<?php echo $row_Recordset1['description']; ?></td> </tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
</table>