查询数据库图片问题,请教!

Question

<div id="Center">
      <div id="C1Pro">
        <div id="C1ProList">
      
        <?
          include("db_mysql.php");
    $sql = "select * from db_image order  by id desc ";
    $rs = mysql_query($sql);
    
    while($row = mysql_fetch_array($rs)){
     
    
  ?>
            <div class="Pro01"><?= $row[bin_data]?></div>  //这个字段是图片 ,但这样查询出来肯定是乱码，请教，这里应该怎样写?           <?
             }
   ?>---------------------------------------------------------------
CREATE TABLE `db_image` (                               
            `id` int(4) unsigned NOT NULL AUTO_INCREMENT,         
            `description` varchar(250) DEFAULT NULL,              
            `bin_data` longblob,                                  
            `filename` varchar(50) DEFAULT NULL,                  
            `filesize` varchar(50) DEFAULT NULL,                  
            `filetype` varchar(50) DEFAULT NULL,                  
            `bin_data_s` longblob,                                
            PRIMARY KEY (`id`)                                    
          ) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8

Answer 1

不建议这样做
这样实现较好
<div class="Pro01"> <?= 图片路径?> </div> 

Answer 2

<div class="Pro01"><img src="showpic.php?id=<?php echo $row['id'];?>" border="0" /></div>
showpic.php
<?php
header("Content-type:image/jpeg");
id = (int)$_GET['id'];
$sql = "select * from db_image where id = $id"; 
$rs = mysql_query($sql); 
$result = mysql_fetch_array($rs);
echo $result['bin_data'];
?>