Question: display img stored in mySQL DB in the table

[skyandfish]

hi, I got a strange question:

I inserted a img in to a table, and the img is stored in the mySQL DB.
E.g, the img size is 100*100, and the code is very simle:

<table width="100 height="100" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="100" height="100">
<?php
echo "<img src=\"showimg.php" width=\"100\" height=\"100\" border=\"1\">";
?>
</td>

</tr>
</table>

showimg.php is a simple php program which display a img stored in the mysql db.

My question is:

The img could be display normally, but there always a small space in the table cell under the img. i.e., The cell is enlarged a little. The cell is 100*100, same as the img size. So I don't know why
there is such a space (about 5 pix high).

If i insert a img from the local drive in the table. Of course everythink is ok. The cell is filled fully with the img

[planetsim]

It would be because of the border maybe. Otherwise i forgot what you need to do i that situation

[JimD]

showimg.php should be able to connect to the database and have something like

echo $row['image'];

in it.

[JimD]

Here, try this. I haven't tested it out so it might not work

<?php
$username = "root";
$password = "";
$hostname = "localhost";	
$dbh = mysql_connect($hostname, $username, $password) 
	or die("Unable to connect to MySQL");
$selected = mysql_select_db("your_db",$dbh) 
	or die("Could not select database");
$result = mysql_query("SELECT * FROM your_table");
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {

echo "$row[image]"; 
}
mysql_close($dbh);

?>

I'm more than 90% sure that there IS an error in my code. Worth a try anyway.

[skyandfish]

hi, thanks the aboved reply.

I want to add some words for the question. The below is the source for the img display script(showimg.php) :

---

<?php
$username = "root";
$password = "";
$hostname = "localhost";

mysql_connect() or die("System error: Failed connecting to DataBase");

mysql_select_db("example") or die("System error: Unable to select database");

$query = "select img, imgtype from imgtable where img_name='example'";
$result = mysql_query($query );

    $row = mysql_fetch_object($result); 
    Header( "Content-Type:".$row->imgtype); 
    echo $row->img;

mysql_close();

My question is when the image is displayed in a table cell,
the size of them are same, but the image will enlarge
the cell a little and there is a samll space in the cell.

I think it's not border or alignment related problem, so
could someone help me on it??