DOWNLOADING FILES FROM A BLOB FIELD

[sCHiuMa]

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!

[fenway]

You'll need to have a serve script that print the appropriate headers... but this isn't a mysql question.