mysql blob display

[opie64]

is it possible to display an array of blob (images) into a table with other data rows?
I'm new and can get all the fields to display but the blob displays as characters. any help would be appreciated.

thanks

[Kudose]

http://www.webmasterworld.com/forum88/9077.htm

[opie64]

$sql = "SELECT * FROM $table_name";

$result = mysql_query($sql);

if (!$result) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}

if (mysql_num_rows($result) == 0) {
echo "No rows found, nothing to print so am exiting";
exit;
}

while ($row = mysql_fetch_assoc($result)) {
echo '<table border="1" align=center class=trwhite>';
echo '<tr>';
echo' <th >First Name<th >Last Name<th >Address<th >Zip Code<th >state<th >picture';

echo' </tr>';
echo ' <tr>';
echo ' <td width="50">';
echo $row["fname"];
echo ';</td>';
echo ' <td width="125">';
echo $row["lname"];
echo '</td>';
echo ' <td width="300">';
echo $row["address"];
echo ' </td>';
echo ' <td width="50">';
echo $row["zip"];
echo '</td>';
echo ' <td width="75">';
echo $row["st"];
echo ' </td>';

// this is where I'm having problems all I get is a bunch of characters if I don't use the header. With the header in it current position I get the web address.

I'm trying this as an array and would like multiple photos and information in a single table.

echo ' <td width="250" rowspan="4">';

header('Content-type: image/jpg');
echo $row["picture"];
echo '</td>';

[HalfaBee]

You can't do it that way, you need to save the blob to a file and use the <img> tag to display it.

[Kudose]

Or use another script to get the blob and use the header type jpeg like you did above. Either way, you can't mix content like you did above. You are trying to output the entire script as a jpeg.

[bradgrafelman]

Well, technically you don't even have to use another script, as you can embed the data inside the HTML using base64 encoding (specs). :p

But yes, the common practice is to point the SRC attribute of the images to a PHP script that is used solely for outputting images (e.g. src="photo.php?id=123).