downloading file (BLOB) from database

[joebudden]

i have displayed a list of files in my database ...

but now i want the user to be able to download a file using a simple hyper link .....

this is my code so far ..........

while (list($artefactId,$filename,$type,$size) = mysql_fetch_array($sql))
{
print '<table width="50%" border="1" cellspacing="0" cellpadding="0">';
print '<tr><td width="50%"><div align="right">Artefact Id:</div></td>';
print '<td width="50%">' . $artefactId . '</td></tr>';
print '<tr><td width="50%"><div align="right">Name:</div></td>';
print '<td width="50%">' . $filename . '</td></tr>';
print '<tr><td width="50%"><div align="right">Type:</div></td>';
print '<td width="50%">' . $type . '</td></tr>';
print '<tr><td width="50%"><div align="right">Size:</div></td>';
print '<td width="50%">' . $size /1024 . " KB" . '</td></tr>';
print '<tr><td width="50%"><div align="right">Download:</div></td>';
print '<td width="50%">';
?>
<a href="view.php?id=<?=$artefactId;?>"><?=$filename;?></a><br>
<?php
print '</td></tr>';
print '<tr>';
print '<td width="50%"><div align="right">';
?>

what do i need to do next ???? any ideas please

[tracy]

Would you be able to add another column with the words 'view file' and the hyperlink attached for each row? Would that work for your site?