how to display mysql results as hyperlinks with php

how do i get the mysql results to display as veiw.php?id=#
this is my code so far





$link = mysql_connect('host', 'username', 'pass')
or die('Could not connect: ' . mysql_error());
echo 'Connected successfully';
mysql_select_db('dbname') or die('Could not select database');


$query = 'SELECT * FROM data';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());

echo "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
echo "\t<tr>\n";
foreach ($line as $col_value) {
echo "\t\t<td>$col_value</td>\n";
}
echo "\t</tr>\n";
}
echo "</table>\n";


mysql_free_result($result);


mysql_close($link);


any help?

what?

-using 'SELECT *' isn't particularly helpful to others looking at your code
-you're iterating over all of the columns, where does the link come in to this?

my question was were would i put the code to select the link from the table

Are you storing URLs in your database and wanting them to be displayed as hyperlinks or are you wanting to create hyperlinks that can then query your database?

which link?
what table?

is there a link in 'data'? (not the best name for a table...)
if so, then it will be one of your columns, so something like


foreach ($line as $col_name=>$col_value) {
if($col_name=='link')
echo '<td><a href="'.$col_value.'">Click Here</a></td>';
else
echo "\t\t<td>$col_value</td>\n";

storing hyperlinks in db