hyperlinking a field with MySQL

[rfigley]

I need to hyperlink a couple of fields in a row to another couple of links in the same row. Each row has a record of a member's name, thier e-mail address and their web address. How do I do this? Of course I want to use the e-mail and web addresses as the hyperlinks. I'll be hyperlinking their name and business, respectively.

Thanks

[amansabharwal]

use the follwoing code:

<table>
<tr><td>Name</td><td>Email</td><td>URL</td></tr>
<?php

while ($row = mysql_fetch_row($result))
{

$name = $row['name'];
$email  = $row['email'];
$url = $row['url'];

echo "<tr><td>".$name."</td><td><a href=\"mailto:".$email."\">".$email."</a></td><td><a href=\"".$url."\">".$url."</a></td></tr>";

}
?>
</table>