下面这代码为什么只显示一张图片?请帮忙看下<table align="center" cellspacing="0" cellpadding="0" border="0" width="750" style="border-right: #666666 1px solid; border-top: #666666 1px solid; border-left: #666666 1px solid; border-bottom: #666666 1px solid">
<tr>
<td width="30"><a href="#" onClick="clickdiv()" id="aa">向左</a></td>
<td><div id="demo" style="overflow: hidden; width: 750px; color: #ffffff">
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td id="demo1"><table width="1710" height="116" cellpadding="0" cellspacing="0" border="0">
<tr>
<?php
include_once("conn/conn.php");
include_once("function.php");
$sqlnewbccd=mysql_query("select top 6 * from tb_photo",$conn);
$infonewbccd=mysql_fetch_array($sqlnewbccd);
if($infonewbccd==false){
echo "<div align=center>对不起,暂无信息!</div>";
}else{
?>
<td width="171"><img src="upfile/<?php echo $infonewbccd["picpath"]; ?>" width="171" height="116" border="0"></td>
<?php
}
?>
</tr>
</table></td>
<td id="demo2"></td>
</tr>
</table>
</div></td>
<td width="30"><a href="#" onClick="Rclickdiv()" id="mcc">向右</a></td>
</tr>
</table>
<script language="javascript">
var speed3=25//速度数值越大速度越慢
var t=false;
var id="aa";
document.getElementById("demo2").innerHTML=document.getElementById("demo1").innerHTML
function Marquee(){
if(document.getElementById("demo2").offsetWidth-document.getElementById("demo").scrollLeft<=0)
document.getElementById("demo").scrollLeft-=document.getElementById("demo1").offsetWidth
else{
document.getElementById("demo").scrollLeft++
}
t=false;
}
function RMarquee(){
if(document.getElementById("demo").scrollLeft<=0)
document.getElementById("demo").scrollLeft+=document.getElementById("demo2").offsetWidth
else{
document.getElementById("demo").scrollLeft--
}
t=true;
}
function clickdiv(){
clearInterval(MyMar)
Marquee();
}
function Rclickdiv(){
clearInterval(MyMar)
RMarquee();
}
var MyMar=setInterval(Marquee,speed3)
document.getElementById("demo").onmouseover=function() {clearInterval(MyMar)}
document.getElementById("demo").onmouseout=function() {if(t){MyMar=setInterval(RMarquee,speed3)}else{MyMar=setInterval(Marquee,speed3)}}
document.getElementById('mcc').onmouseout=function(){clearInterval(MyMar);MyMar=setInterval(RMarquee,speed3);}
document.getElementById('aa').onmouseout=function(){clearInterval(MyMar);MyMar=setInterval(Marquee,speed3);}
</script>
<tr>
<td width="30"><a href="#" onClick="clickdiv()" id="aa">向左</a></td>
<td><div id="demo" style="overflow: hidden; width: 750px; color: #ffffff">
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td id="demo1"><table width="1710" height="116" cellpadding="0" cellspacing="0" border="0">
<tr>
<?php
include_once("conn/conn.php");
include_once("function.php");
$sqlnewbccd=mysql_query("select top 6 * from tb_photo",$conn);
$infonewbccd=mysql_fetch_array($sqlnewbccd);
if($infonewbccd==false){
echo "<div align=center>对不起,暂无信息!</div>";
}else{
?>
<td width="171"><img src="upfile/<?php echo $infonewbccd["picpath"]; ?>" width="171" height="116" border="0"></td>
<?php
}
?>
</tr>
</table></td>
<td id="demo2"></td>
</tr>
</table>
</div></td>
<td width="30"><a href="#" onClick="Rclickdiv()" id="mcc">向右</a></td>
</tr>
</table>
<script language="javascript">
var speed3=25//速度数值越大速度越慢
var t=false;
var id="aa";
document.getElementById("demo2").innerHTML=document.getElementById("demo1").innerHTML
function Marquee(){
if(document.getElementById("demo2").offsetWidth-document.getElementById("demo").scrollLeft<=0)
document.getElementById("demo").scrollLeft-=document.getElementById("demo1").offsetWidth
else{
document.getElementById("demo").scrollLeft++
}
t=false;
}
function RMarquee(){
if(document.getElementById("demo").scrollLeft<=0)
document.getElementById("demo").scrollLeft+=document.getElementById("demo2").offsetWidth
else{
document.getElementById("demo").scrollLeft--
}
t=true;
}
function clickdiv(){
clearInterval(MyMar)
Marquee();
}
function Rclickdiv(){
clearInterval(MyMar)
RMarquee();
}
var MyMar=setInterval(Marquee,speed3)
document.getElementById("demo").onmouseover=function() {clearInterval(MyMar)}
document.getElementById("demo").onmouseout=function() {if(t){MyMar=setInterval(RMarquee,speed3)}else{MyMar=setInterval(Marquee,speed3)}}
document.getElementById('mcc').onmouseout=function(){clearInterval(MyMar);MyMar=setInterval(RMarquee,speed3);}
document.getElementById('aa').onmouseout=function(){clearInterval(MyMar);MyMar=setInterval(Marquee,speed3);}
</script>
$sqlnewbccd = mysql_query("SELECT * FROM tb_photo LIMIT 6",$conn); //MySQL写法
查询成功后要用循环来输出所有的记录:
$sqlnewbccd = mysql_query("SELECT * FROM tb_photo LIMIT 6",$conn);
if (mysql_num_rows($sqlnewbccd) < 1) echo "<div align=center>对不起,暂无信息!</div>";
else {
while($infonewbccd=mysql_fetch_array($sqlnewbccd)) {
echo '<td width="171"><img src="upfile/'.$infonewbccd["picpath"].'" width="171" height="116" border="0"></td>';
}
}