<?php
//调用副表字段 a.字段名 主表字段 b.字段名
$sql = $empire->query("select a.id,a.morepic,b.id,b.picsay,b.title from {$dbtbpre}ecms_photo_data_1 as a LEFT JOIN {$dbtbpre}ecms_photo as b ON a.id=b.id where b.userid='$userid' limit 1");
while($r=$empire->fetch($sql)){
if($r[morepic]){
$rexp="\r\n";
$fexp="::::::";
$rr=explode($rexp,$r[morepic]);
$morepicTotle=count($rr);
for($i=0;$i<$morepicTotle;$i++)
{
$fr=explode($fexp,$rr[$i]);
$smallpic = $fr[0]; //小图
$url = $fr[1]; //大图
$smalltext = $fr[2]; //简介
$title=$r[title]; //标题
?>
图1地址:<?= $url ?>
<?php
}
}
}
?>
//调用副表字段 a.字段名 主表字段 b.字段名
$sql = $empire->query("select a.id,a.morepic,b.id,b.picsay,b.title from {$dbtbpre}ecms_photo_data_1 as a LEFT JOIN {$dbtbpre}ecms_photo as b ON a.id=b.id where b.userid='$userid' limit 1");
while($r=$empire->fetch($sql)){
if($r[morepic]){
$rexp="\r\n";
$fexp="::::::";
$rr=explode($rexp,$r[morepic]);
$morepicTotle=count($rr);
for($i=0;$i<$morepicTotle;$i++)
{
$fr=explode($fexp,$rr[$i]);
$smallpic = $fr[0]; //小图
$url = $fr[1]; //大图
$smalltext = $fr[2]; //简介
$title=$r[title]; //标题
?>
图1地址:<?= $url ?>
<?php
}
}
}
?>