你把result2的东西放到外层循环里就搞定了。
如:
while($row1=mysql_fetch_row($result1))
{
echo $row1[1];
$query = "...";
$result2 = mysql_query($query);
while($res2=mysql_fetch_row($result2))
{
echo "<br>".$res2[1]."<br>";
}
}
如:
while($row1=mysql_fetch_row($result1))
{
echo $row1[1];
$query = "...";
$result2 = mysql_query($query);
while($res2=mysql_fetch_row($result2))
{
echo "<br>".$res2[1]."<br>";
}
}
while($res2=mysql_fetch_row($result2)){}
一次后,$result2的指针已移到末尾,所以就打不出了你需要用mysql_data_seek移动指针到开始处