<span class="zinput">
<?PHP
echo "<div class='iright' style='padding-bottom:1px;'>";
echo "<div class='title'>最热排行</div>";$sql = "select title,vpath,islink,click,bid from videomain where videoid = $videoid limit 1";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$title = $row[0];
$click = $row[3];
mysql_free_result($result);
echo "<div width='1' class='videotitle'>".$title."</div>";
echo "<div width='113' valign=top>人气:".$click."</div>";
mysql_free_result($result);
echo "<div class='videoclick'></div>";
echo "</div>";echo "</div>";?>
</span>目前只显示一个title和click
怎么能让它显示指定多个title按click指排列呢?
<?PHP
echo "<div class='iright' style='padding-bottom:1px;'>";
echo "<div class='title'>最热排行</div>";$sql = "select title,vpath,islink,click,bid from videomain where videoid = $videoid limit 1";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
$title = $row[0];
$click = $row[3];
mysql_free_result($result);
echo "<div width='1' class='videotitle'>".$title."</div>";
echo "<div width='113' valign=top>人气:".$click."</div>";
mysql_free_result($result);
echo "<div class='videoclick'></div>";
echo "</div>";echo "</div>";?>
</span>目前只显示一个title和click
怎么能让它显示指定多个title按click指排列呢?
<span class="zinput">
<?PHP
echo " <div class='iright' style='padding-bottom:1px;'> ";
echo " <div class='title'> 最热排行 </div> "; $sql = "select title,vpath,islink,click,bid from videomain where videoid = $videoid limit 1";
$result = mysql_query($sql);
while($row = mysql_fetch_row($result))
{
$title = $row[0];
$click = $row[3];
echo " <div width='1' class='videotitle'> ".$title." </div> ";
echo " <div width='113' valign=top> 人气:".$click." </div> ";
}echo " </div> "; ?>
</span>