Mi aiutate a convertire il contenuto di un campo BLOB di mysql in immagine di php?
QUESTO E' QUELLO CHE MI ESCE IN PHP:
/9j/4AAQSkZJRgABAgAAZABkAAD/7AARRHVja3kAAQAEAAAAZAAA/+4ADkFkb2JlAGTAAAAAAf/bAIQAAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBA QEBAQEBAQEBAQICAgICAgICAgICAwMDAwMDAwMDAwEBAQEBAQE CAQECAgIBAgIDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDA wMDAwMDAwMDAwMDAwMDAwMDAwMD/8AAEQgBagMCAwERAAIRAQMRA
Questa è la mia query:
$sql="select *
from $tabella
order by codImg
";
$result=mysql_query($sql) or die(mysql_error());
$number = mysql_numrows($result);
echo "<table border=\"1\" p class=\"Stile3\" align=\"left\"><tr>
<th><font color=\"red\">FOTO</font></th></tr>";
for($i=0;$i<$number;$i++){
$id=mysql_result ($result,$i, "id");
$codImg=mysql_result ($result,$i, "codImg");
echo "<tr><td>$codImg</td></tr>";
}
echo "</table>";
COSA STO SBAGLIANDO?