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>
$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 />
