hyperlink in php search result?

Question

i am new to php How do i make my search result,ie title is show such that is hyper link to a page? i have already iput a url column in the table in phpmyadmin

the php code is shown below

<?php
$connect = mysql_connect("localhost", "root","") or die(mysql_error());

mysql_select_db("books",$connect) or die(mysql_error());

$sql = "SELECT * FROM bookinfo";

if (isset($_POST['search'])) {
$search_term = mysql_real_escape_string($_POST['searchbox']);

$sql .= " WHERE title = '{$search_term}'";
$sql .= " OR author = '{$search_term}'";

}

$query = mysql_query($sql) or die(mysql_error());


?>
<form name="searchform" method="POST" >
Search:<input type="text" name="searchbox" />
<input type="submit" name="search" value="search book" />
</form>
<table width="70%" cellpadding="5" cellspace="5">
<tr>
    <td>Title</td>
    <td>Author</td>
    <td>Price</td>


</tr>
<?php while ($row = mysql_fetch_array($query)) {
?>   
<tr>
    <td><?php echo $row['title']; ?></td>
    <td><?php echo $row['author']; ?></td>
    <td><?php echo $row['price']; ?></td>

</tr>
<?php }
 ?>
</table>

Answer 1

Hyperlinks are made with the a (or "anchor") tag in HTML. Simply include one in your output:

<td><a href="<?php echo $row['url']; ?>"><?php echo $row['title']; ?></a></td>