Display JPG stored in MySQL Binary record
I have successfully stored a standard JPG photograph in MySQL using a simple DA insert page. The Photofile field structure is setup as ( longblob, BINARY ).
Now I'd like to recall that file and display this image as desired.
How is the <img> operation accomplished?
<table class="WADAResultsTable" border="0" cellpadding="0" cellspacing="0">
<tr>
<th class="WADAResultsTableHeader">Date:</th>
<th class="WADAResultsTableHeader">Description:</th>
<th class="WADAResultsTableHeader">Filename:</th>
<th class="WADAResultsTableHeader"> </th>
</tr>
<?php do { ?>
<tr class="<?php echo $WARRT_AltClass1->getClass(true); ?>">
<td class="WADAResultsTableCell"><a href=""></a><?php echo($row_WADAfiles['Date']); ?></td>
<td class="WADAResultsTableCell"><?php echo($row_WADAfiles['Description']); ?></td>
<td class="WADAResultsTableCell"><?php echo $row_WADAfiles['Photofile']; ?></td>
<td class="WADAResultsTableCell"><a href="<?php echo $row_WADAfiles['Photofile']; ?>"><img src="images/mini_info.png" border="0" /></a></td>
</tr>
<?php } while ($row_WADAfiles = mysql_fetch_assoc($WADAfiles)); ?>
</table>
I'm getting the following error...
The requested URL /102_2575.JPG was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Thanks in advance.