how show image from table to page

mfa786

sir i use php with mysql that have blob filed
i save the image in that field

see my code
<?php
mysql_connect("localhost", "root", "") or die(mysql_error());

mysql_select_db("cdcol") or die(mysql_error());

global $result;

$result = mysql_query("SELECT * FROM cds") or die(mysql_error());

echo "<table border='1'>
<tr>
<th>First Name</th>
<th>Last Name</th>
</tr>";

while($row = mysql_fetch_array( $result ))
{
echo "<tr>";
echo "<td>" . $row['titel'] . "</td>";
echo "<td>" . $row['jahr'] . "</td>";
echo "<td>" . $row['phh'] . "</td>";

echo "</tr>";
}
echo "</table>";

but sri when i show image in page the php give me error

please give me idea how i show my image in page

Flyier

You can write what error gives you ...

bradgrafelman

Which one of the table columns contains the image data? Is there an "id" column set to auto_increment in this table? If not, you should add one - this allows you to identify a certain row by its ID number.

If you're trying to output the image data from the table, you need to do something like this:

echo "<td><img src='image.php?id=" . $row['id'] . "'></td>";

Then, in the image.php script, you'd do something like:

$id = (isset($_GET['id']) ? intval($_GET['id']) : FALSE);
if($id === FALSE)
    die('No id specified in URL.');

$query = "SELECT `column_that_has_image_data` FROM `cds` WHERE `id`= $id";
$exec = mysql_query($query);

header('Content-Type: image/jpeg'); // change this to the appropriate image format
echo mysql_result($exec, 0);