trying to retrieving a file from database

[Kallemann]

I'm trying to make a page where a user can download a file from a blob field in my database.

$result = "SELECT * FROM file where foreign_id='$id';";
$resultSet = mysql_query($result);

while( $row = mysql_fetch_array( $resultSet ) )
{
echo(" <a href='".$row[ "bin_data"]."'>".$row[ "filename"]."</a><br>");
}

This prints the filename in the database, but it does not open the file when you press the link. What's wrong?

Karl

[drawmack]

http://www.onlamp.com/pub/a/php/2000/09/15/php_mysql.html

[macosxguy]

I too would like to have users download binary files from mysql, but using a text link. The OnLamp example given by drawmac results in the file bursting onto your hard drive when you load the page. How can we control the download of the file with a text link?