how do i make a column link to mysql

[frank_solo]

I have a table where it displays some data. How do I make this

echo "<td>" . $row['title'] . "</td>";

into a link?

[JohnOP]

echo "<td><a href='" . $row['title'] . "'>link</a></td>";

[frank_solo]

Thanks JohnOP for the response. I got it to link to another page like so

echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'><a href='classified/searchapts/index.php'" . $row['title'] . "'>".$row['title']."</a></td>";

My second question is how do i start to show the data on the href page for the item in the row. What function can I use or does anyone know of a good tutorial?

[frank_solo]

Ok so where can I put this

" . $row['title'] . "

in this

echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'><a href='index.php?id=$title'>$title</a></td>";

 

[frank_solo]

Ok I figured how to insert it to this

echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'><a href='classified/searchapts/index.php?id=$title'>" . $row['title'] . "</a></td>";

but now what do I write in the page. In this case index.php to display the info of that row is it this

<?php
include "dbaptsConfig.php";
$query = mysql_query("SELECT * FROM apartments WHERE title ='$title'");
while($row = mysql_fetch_array($query)) {
  echo $row['title'];
  echo '<br>';
  echo $row['town'];
  echo '<br>';
  echo $row['rooms'];
  echo '<br>';
  
}
?>

[frank_solo]

Please I need help?