Retrieving a blob?

[jedimastermopar]

Ok I have a table with a blob field that contains an excel document(*.xls) how would I code a link so someone could download this blob?

[whizard]

not sure, but would this work?

<?php
$query = "SELECT `blob` FROM `table` WHERE `id` = $id";

//Run Query

$blob = $result['blob'];

?>
<a href="<?php print "folder/".$blob; ?>">Download <?php print $blob; ?></a>

HTH
Dan