sql语句重复 while循环取不出来

[owillber]

$sqlthree="SELECT filename,ftitle,one,two,three,four,five,newstime,datetime from table where classid='116' ";
$rthree = mysql_query($sqlthree, $con);

$sqlfive="SELECT filename,ftitle,one,two,three,four,five,newstime,datetime from table where classid='117' ";
$rfive = mysql_query($sqlfive, $con);

<?php
while($rowthree = mysql_fetch_row($rthree))
{
echo "<td class='font-12' align='center' >";
echo "<a href='$rowthree[0].html' style='text-decoration:none;' >$rowthree[1]</a>";
echo "</td>";
echo "<td class='font-12' align='center' >";
echo $rowthree[8];
echo "</td>";
echo "<td class='font-12' align='center' >";
echo $rowthree[2].' '.$rowthree[3].' '.$rowthree[4];
echo "</td>";
echo "<td class='font-12' align='center' >";
echo $rowthree[7];
echo "</td>";
}

?>

<?php
while($rowfive = mysql_fetch_row($rfive))
{
echo "<td class='font-12' align='center' >";
echo "<a href='$rowfive[0].html' style='text-decoration:none;' >$rowfive[1]</a>";
echo "</td>";
echo "<td class='font-12' align='center' >";
echo $rowfive[8];
echo "</td>";
echo "<td class='font-12' align='center' >";
echo $rowfive[2].' '.$rowfive[3].' '.$rowfive[4].' '.$rowfive[5].' '.$rowfive[6];
echo "</td>";
echo "<td class='font-12' align='center' >";
echo $rowfive[7];
echo "</td>";
}

?>

while只循环了 three 数据 five 没有读取到 怎么才能读取到？

[wldzjj]

我试了你的代码 在我这完全好用，并没有错，你在看看classid =117里面有没有数据

[shaogu8]

想不到写得比复杂还复杂了点！

[床上等您]