display images in HTML

[normanjg]

I need to display images in a page called from a database. I am new to all this so I am only pulling the binary code of the image versus the actual image. Any help would be appreicated. The code I have as of now is as follows:

<?
 
  $SelectID = '113';    
 
    MYSQL_CONNECT("localhost","db","dbpw"); 
    mysql_select_db("db"); 
 
$sql = " SELECT * FROM ad where id = $SelectID LIMIT 1"; 
$result = mysql_query($sql); 
 
header("Content-type: image/jpeg");
  while($row = mysql_fetch_array($result))
    { 
  echo "
<div id=\"container\">
<table border=1 width=450 bgcolor=black>
<tr>
<td><font face=\"Tahoma\" size=\"1\" color=\"white\">$row[city] ,$row[state]</font></td>
</tr>
<tr>
<td><font face=\"Tahoma\" size=\"1\" color=\"white\">$row[year]</font></td>
</tr>
<tr>
<td><font face=\"Tahoma\" size=\"1\" color=\"white\">$row[id]</font></td>
</tr>
<tr>
<td><font face=\"Tahoma\" size=\"1\" color=\"white\">$row[make]</font></td>
</tr>
<tr>
<td><font face=\"Tahoma\" size=\"1\" color=\"white\">$row[model]</font></td>
</tr>
<tr>
<td><font face=\"Tahoma\" size=\"1\" color=\"white\">$row[color]</font></td>
</tr>
<tr>
<td><font face=\"Tahoma\" size=\"1\" color=\"white\">$row[cc]</font></td>
</tr>
<tr>
<td><font face=\"Tahoma\" size=\"1\" color=\"white\">$row[mileage]</font></td>
</tr>
<tr>
<td><font face=\"Tahoma\" size=\"1\" color=\"white\">$row[description]</font></td>
</tr>
<tr>
<td><font face=\"Tahoma\" size=\"2\" color=\"white\">$row[price]</font></td>
</tr>
<tr>
<td>print $row[image1] </td>
</tr>
<tr>
</table> 
</div>"; 
    } 
 
MYSQL_CLOSE(); 
 
?>

[Atli]

Hi.

You can't just echo the content of the image into the HTML.
Well, technically it could be done, but the normal way is much better at the moment.

What you want to do is use a normal <img> tag, but instead of calling an actual image it would call a .php script that acts as an image.
A browser will see no difference between a typical JPEG file and a PHP script that sets the Content-Type header to image/jpeg and echoes the content of a JPEG image.

I wrote an article about uploading and displaying files from a MySQL database in the PHP HowTo section. You can see it here.
Maybe that will help.

[chelvan]

hi
to display the image just do like the normal html img tag. that will display the image.

<td><img src='....../$row[image1]'> </td>

chel-1

[Atli]

hi
to display the image just do like the normal html img tag. that will display the image.

<td><img src='....../$row[image1]'> </td>

chel-1

That won't work if the database is returning the binary data for the image.

The src attribute of an <img> tag (by default) expects the location of the image, not the image data.