Display hyperlink from sql database

[chrismellor]

I have a table with seminar details i.e. code date title etc. I have added "hyperlink" and "details" fields. "Hyperlink" field has www.someone.com in it. "Details" field to be the click on field when result returned.

So how do I return a list of seminar titles date etc with a hyperlink on "details" to take me to another page with all seminar details displayed.

This is as far as I got before my hair started turning grey.

$sql="SELECT Code, DATE_FORMAT(date, '%d-%m-%y'), Title, CONCAT('<a href= \"http://',hyperlink'\">'SOMENAME,'</a>') AS Details FROM seminar2 ";

$result=mysql_query($sql,$conn)
or die("Could not execute query");

print"<br>";

    $rows=mysql_num_rows($result);
    $columns=mysql_num_fields($result);

print"<b>";
print "<table border='2' cellpadding='2' cellspacing='0' style='font-family: Arial; font-size: 8pt; color: #000080' bordercolor='#FFFFFF' width='100%' id='AutoNumber1' bgcolor='#99CCFF'>";
print"<tr>";
print"<td><b>Code</td>";
print"<td><b>Date</td>";
print"<td><b>Title</td>";
print"<td><b>Details</td>";

print"</tr>";
print"</b>";

while ($row=mysql_fetch_row($result))
{ 
print"<tr>";
$i=0;
	while ($i < $columns)
		{
		print "<td>";
		print"$row[$i]";
		print"</td>";
		$i++;
		}

 print"</tr>";

     }

print "</table>";

mysql_close($conn);

?>

Please help

[subwayman]

$sql="SELECT Code, DATE_FORMAT(date, '%d-%m-%y') as sdate, Title, hyperlink, SOMENAME FROM seminar2 "; 
.
.
.
while ($row=mysql_fetch_array($result)) 
{ 
  print"<tr>"; 
  print '<td>' . $row['Code'] . '</td>'; 
  print '<td>' . $row['sdate'] . '</td>'; 
  print '<td>' . $row[Title] . '</td>'; 
  print '<td><a href="HTTP://' . $row['hyperlink'] . '">. $row['SOMEONE']. '</a></td>'; 
  Print '</tr>'

} 

}

[chrismellor]

Many thanks for your help much appreciated