mysql 双循环对应有关问题

mysql 双循环对应问题

<div><br />
<dl><br />
<dt><br />
<?php <br />
$strSql1 ="Select id From menu where  subs_pid='13'   Order By time ASC limit 0,11";<br />
$res1       =  _query($strSql1); <br />
while (!!$rs=_fetch_array($res1)){<br />
	$subID    = $rs['id'];<br />
echo "<span><a href=\"/#\" >地板(等建材栏目)</a></span>\n";<br />
}<br />
mysql_free_result($res1);<br />
<br />
?><br />
</dt><br />
<br />
<?php <br />
$strSql2 ="select pic1 from newslist where  n_ppid='".$subID."'  order by n_time desc limit 0,12";<br />
//$subID为建材栏目ID...如何通过第一步循环的建材栏目ID.循环出对应的建材图片<br />
?><br />
<br />
<dd><div>吊顶产品图片</div></dd><br />
<dd><div>门窗产品图片</div></dd><br />
<dd><div>地板产品图片</div></dd><br />
<dd><div>家电产品图片</div></dd><br />
</dl><br />
</div>

附带图片效果
关键里面有html标签,我新手有点反应不过来了...

------解决方案--------------------
好吧，就按你的结构
第一节

$strSql1 = "Select id From menu where  subs_pid='13'   Order By time ASC limit 0,11";<br />
$res1 =  _query($strSql1); <br />
while (!!$rs=_fetch_array($res1)){<br />
  $subID[]    = $rs['id'];//注意这里<br />
  echo "<span><a href=\"/#\" >地板(等建材栏目)</a></span>\n";<br />
}<br />
mysql_free_result($res1);<br />

第二节

foreach($subID as $id) {<br />
  echo '<dd><div>';<br />
  $strSql2 ="select pic1 from newslist where  n_ppid='".$id."'  order by n_time desc limit 0,12";<br />
  //这里是循环输出图片的代码<br />
  echo '</div></dd>';<br />
}<br />