如何在同一标签中显示三个不同文件夹中的图像 - How to display the images in three different folder in same tag

How to display the images in three different folder in same tag

 $sql=mysql_query(
"SELECT ssmid, image FROM user_photos_offline WHERE ssmid='$ssmid' AND status='1'
UNION
SELECT ssmid, image FROM user_profile_pic WHERE ssmid='$ssmid' AND status='1'
UNION
SELECT ssmid, image FROM user_family_photos WHERE ssmid='$ssmid' AND status='1' " 
);
while($row=mysql_fetch_assoc($sql)){
 echo  $result = $row['image'];// Here i got all images name from DB
 }

这个代码工作得很好，$结果我从DB得到所有的值，但是这个图像我移动了三个不同的文件夹，这些是文件夹名称裁剪图像，家庭照片，个人资料照片如何在<img src='?????'>

中显示图像文件夹名称

mysql_*扩展在PHP 5.5.0中被弃用，并在PHP中被删除7.0.0. 相反，应该使用MySQLi或PDO_MySQL扩展名。

试试这个

$folder_names = array("cropped-images","profile-photos","family-photos");
$i = 0;
while($row=mysql_fetch_assoc($sql)){
  echo  $result = $row['image'];// Here i got all images name from DB
  echo "<img src='".$folder_names[$i]."/".$result."'>";      
  $i++;
}