im making a simple library archive in my office, and i want to display from a search result some text data, date, and a link to download a zip file. the file is stored in a blob binary field...
mysql_select_db("cds2008");
$search=$_POST["search"];
$result = mysql_query("SELECT * FROM estudios WHERE pueblo LIKE '%$search%'");
while($r=mysql_fetch_array($result))
{
$numero=$r["numero_de_serie"];
$fecha=$r["fecha"];
$estudio=$r["estudio"];
$pueblo=$r["pueblo"];
$cliente=$r["cliente"];
$files=$r["files"];
echo "<hr><br><strong>Numero de Serie:</strong> $numero <br><strong>Fecha:</strong> $fecha <br> <strong>Estudio:</strong> $estudio <br> <strong>Pueblo:</strong> $pueblo <br> <strong>Cliente:</strong> $cliente <br><strong>Files:</strong> $files" </a><br><br>";
}
?>
the field with the file is named "files" and i want it to show in the results as a link so anyone can download the file, PLEASE HELP!