depends on what you're storing. If you're storing an image do this:
Reference URL
Get the blob contents, in a file, send the image headers, print the contents...
<?php
// Assuming you've done your query, working with results now
while($row = mysql_fetch_array($result))
{
echo '<img src="showimage.php?id='.$row['id'].'"><br><br>';
}
?>
showimage.php
<?php
if(!isset($_GET['id']))
{
die();
}
$blob = mysql_query("SELECT blob_column FROM `table` WHERE id='".$_GET['id']."'");
$img = mysql_result($blob, 0, 'blob_column');
header('Content-type: image/gif');
print($img);
?>
~Brett
