Downloading files from database

[chico1st]

okay i have a pdf document in a database which i am downloading using this code.

to take it out i use this code:
[b]print "<a href='download.php?id=$id'>PDF!</a>";[/b]

where download.php is :
<?php
if(isset($_GET['id']))
{
// if id is set then get the file with the id from database

include "../../Lib.php";
$dbConn = connectToSpy();

$id    = $_GET['id'];
$query = "SELECT name, type, size, content " .
        "FROM document WHERE documentID = '$id'";

$result = mysql_query($query, $dbConn) or die('Error, image retrieve failed');
list($name, $type, $size, $content) = mysql_fetch_array($result);


header("Content-type: $type");
echo $content;

exit;
}

?>

But i was wondering how i can make a link that directly makes you download the file instead of opening it?

[fenway]

You just need to write out the appropriate content headers.