<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指排列呢?
echo ".................";
}
limit 记录始偏移量,想取的记录数
输出的时候用
while($row=mysql_fetch_array($result))
{
//输出数组$row;
}