Home >Backend Development >PHP Tutorial > mysql 双循环对应有关问题

mysql 双循环对应有关问题

WBOY
WBOYOriginal
2016-06-13 12:57:44806browse

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

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn