21,886
社区成员
发帖
与我相关
我的任务
分享
$list=array();
$list2=array();
$query=DB::query("SELECT * FROM ".DB::table('st')." WHERE kid=".$_GET['new']. " ORDER BY orderID, numP");
while($xmlb=DB::fetch($query))
{
$list[]=$xmlb;
$query2=DB::query("SELECT * FROM ".DB::table('k_sk')." WHERE id=".$xmlb['id']." ORDER BY id");
$xmlb2=DB::fetch($query2);
$list2[]=$xmlb2;
}
<!--{if $list}-->
<!--{loop $list $xmlb}-->
<p><span style='color:red;font-family: 宋体;font-size:12pt'>$xmlb['numP']、</span></p>
<p><span style='font-family: 宋体;font-size:12pt'>$xmlb2['nr']</span></p>
<!--{/loop}-->
<!--{else}-->
<p style="width:900px; margin:200px auto; text-align:centre;">无内容</p>
<!--{/if}-->
while($xmlb=DB::fetch($query))
{
$query2=DB::query("SELECT * FROM ".DB::table('k_sk')." WHERE id=".$xmlb['id']." ORDER BY id");
$xmlb2=DB::fetch($query2);
$xmlb['xmlb'] = $xmlb2;
$list[]=$xmlb;
}
这样就不用$list2了 你用DB::fetch($query2);如果有多条匹配的记录就只返回一条了 应该有那个方法返回所有 我不记得了
<!--{if $list}-->
<!--{loop $list $xmlb}-->
<p><span style='color:red;font-family: 宋体;font-size:12pt'>$xmlb['numP']、</span></p>
<p><span style='font-family: 宋体;font-size:12pt'>
<!--{loop $xmlb['xmlb'] $b}-->
$b['字段名'];
<!--{/loop}-->
</span></p>
<!--{/loop}-->
<!--{else}-->
<p style="width:900px; margin:200px auto; text-align:centre;">无内容</p>
<!--{/if}-->
大概这样子