Trying to display a blob ...
Posted: Tue Oct 20, 2009 7:50 am
Am trying to display some php fields in a html table....
all ok except the blob file 'person_photo' which displays as garbage...
is it syntax or me ??
all ok except the blob file 'person_photo' which displays as garbage...
is it syntax or me ??
Code: Select all
[color=#BF0000]<?php[/color]
$query = "select * FROM people WHERE person_country = 81" ;
$data = mysql_query($query) ;
Print $query;
Print "<table width='100%' height='1000' border cellpadding=1>";
while($info = mysql_fetch_array( $data ))
{
Print "<tr>";
Print "<td height='59'> </td>";
Print "<td >Lastname : " .$info['person_lastname'] . "</td>";
Print "<td width='20%> </td>";
Print "<td width='18%'>Firstname : ".$info['person_firstname'] . "</td>";
Print "<td width='18%'> </td>";
Print "<td width='22%' rowspan='5'>Photo : " . header('Content-Type: image/jpeg') .$info['person_photo'] . "</td>";
Print "<td width='5% rowspan='7'> </td>";
Print "</tr>";
Print "</table>";
}
[color=#BF0000]?>[/color]