Display image from database using php

[gowthambj]

i have a table named tablenamevehicl e which contains about 15 fields. all are text fields and one is image field stored in blob data type. I am able to display all the text from the other fields of the table but the image is being displayed as the binary data. Please help me out to display the image in its form. Code is

 
<table width="950" align="center" border="0">
  <tr align="center">
    <td align="center" class="menubar1"><br/> <font size="+3">Vehicles</font></td>
    </tr>
    <tr>
    <td>
<div id="container">


<?php
/*set varibles from form */
$searchterm1 = $_POST['searchterm1'];
trim ($searchterm1);
/*check if search term was entered*/
if (!$searchterm1){
        echo 'Please enter a search term.';
}
/*add slashes to search term*/
if (!get_magic_quotes_gpc())
{
$searchterm1 = addslashes($searchterm1);
}



$searchterm2 = $_POST['searchterm2'];
trim ($searchterm2);
/*check if search term was entered*/
if (!$searchterm2){
        echo 'Please enter a search term.';
}
/*add slashes to search term*/
if (!get_magic_quotes_gpc())
{
$searchterm2 = addslashes($searchterm2);
}




/*set varibles from form */
$searchterm5 = $_POST['searchterm5'];
trim ($searchterm5);
/*check if search term was entered*/
if (!$searchterm5){
        echo 'Please enter a search term.';
}
/*add slashes to search term*/
if (!get_magic_quotes_gpc())
{
$searchterm5 = addslashes($searchterm5);
}



/*set varibles from form */
$searchterm4 = $_POST['searchterm4'];
trim ($searchterm4);
/*check if search term was entered*/
if (!$searchterm4){
        echo 'Please enter a search term.';
}
/*add slashes to search term*/
if (!get_magic_quotes_gpc())
{
$searchterm4 = addslashes($searchterm4);
}






/* connects to database */

$username="root";
$password="webmaster";
$database="demo1";
mysql_connect("localhost","root","webmaster");
@mysql_select_db($database) or die( "Unable to select database");
/*query the database*/
$query = "select * from tablenamevehicle where field4_name like '%".$searchterm4."%' and field5_name like '%".$searchterm5."%' and field1_name like '%".$searchterm1."%'and field2_name like '%".$searchterm2."%'";

$result = mysql_query($query);
/*number of rows found*/
$num=mysql_numrows($result);

mysql_close();
?>

<table border="0" cellspacing="2"cellpadding="20">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Type of Vehicle</font></th>
<th><font face="Arial, Helvetica, sans-serif">Version</font></th>
<th><font face="Arial, Helvetica, sans-serif">Brand</font></th>
<th><font face="Arial, Helvetica, sans-serif">Model</font></th>
<th><font face="Arial, Helvetica, sans-serif">Model</font></th>
<th><font face="Arial, Helvetica, sans-serif">Model</font></th>
<th><font face="Arial, Helvetica, sans-serif">Model</font></th>
<th><font face="Arial, Helvetica, sans-serif">Model</font></th>
<th><font face="Arial, Helvetica, sans-serif">Model</font></th>
<th><font face="Arial, Helvetica, sans-serif">Model</font></th>
<th><font face="Arial, Helvetica, sans-serif">Model</font></th>
<th><font face="Arial, Helvetica, sans-serif">Model</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"field1_name");
$f2=mysql_result($result,$i,"field2_name");
$f3=mysql_result($result,$i,"field3_name");
$f4=mysql_result($result,$i,"field4_name");
$f5=mysql_result($result,$i,"field5_name");
$f6=mysql_result($result,$i,"field6_name");
$f7=mysql_result($result,$i,"field7_name");
$f8=mysql_result($result,$i,"field8_name");
$f9=mysql_result($result,$i,"field9_name");
$f10=mysql_result($result,$i,"field10_name");
$f11=mysql_result($result,$i,"field11_name");
$f12=mysql_result($result,$i,"field12_name");
[B]$f13=mysql_result($result,$i,"image");[/B]
?>

<tr>

<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f6; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f7; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f8; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f9; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f10; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f11; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f12; ?></font></td>
[B]<td><font face="Arial, Helvetica, sans-serif"><?php echo $f13; ?></font></td>[/B]

</tr>

<?php
$i++;
}
?>
</table>
</div>
</td>

*/


$f13=mysql_resu lt($result,$i," image"); is the place where i am calling the image to be displayed
*?
help needed plesae

[Dormilich]

as AdaHacker explained, use base64 data or use an <img> tag.

PLEASE DO NOT CROSS POST YOUR QUESTION IN DIFFERENT FORUMS!