Download binary file from mySQL

[daniedb]

Hi,

I've search around on several pages and got a script to download bin files from DB. Testing the script online before downloading it works, but implementing it on my localhost, everything works fine from uploading, displaying data except to open the actual file - Opens blank IE page or gives message file is damaged

See below how I call the page and coding from download page

echo "<a href=downloadview.php?id=$id>$name</a> - $type - $size<br>";

<?php
include '../files/connect.php';

$sql = "SELECT content, type FROM upload WHERE id=$id";

$result = @($sql, $db);

$data = @mysql_result($result, 0, "content");
$type = @mysql_result($result, 0, "type");

header("Content-type: $type");
// header("Content-Description: PHP Generated Data");
echo $data;

?>

[dagon]

your header() looks wrong to me, there's some examples in the manual for doing just this.

[daniedb]

Thanx Dagon, I tried all posible examples and all same result.