下面这代码为什么只显示一张图片?请帮忙看下<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> 

解决方案 »

  1.   

    $sqlnewbccd=mysql_query("select top 6 * from tb_photo",$conn); //这是MSSQL的语法
    $sqlnewbccd = mysql_query("SELECT * FROM tb_photo LIMIT 6",$conn); //MySQL写法
      

  2.   

    另外,按你贴出的代码,应该是一张图片也不会显示,而是输出"暂无信息"。
    查询成功后要用循环来输出所有的记录:
    $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>';
        }
    }