获取数据，没有得到正确的数据

问题描述：

我试图获取基于时间的前10项（与time前10个值项柱）。我有以下代码。

<?php 
    include_once("connect.php"); 
    $sql = "SELECT * FROM scores order by time desc limit 10"; 
    $query = mysql_query($sql) or die("systemResult=Error"); 
    $counter = mysql_num_rows($query); 

    if($counter>0) 
    { 
     print("systemResult=Success"); 
     $array = mysql_fetch_array($query); 

     foreach($array as $data) 
     { 
      $athleteName = $data["athleteName"]; 
      $email = $data["email"]; 
      $time = $data["time"]; 
      $timeStamp = $data["timeStamp"]; 
      $country = $data["country"]; 

      print "&athleteName=" . $athleteName; 
      print "&email=" . $email; 
      print "&time=".$time; 
      print "&timeStamp=".$timeStamp; 
      print "&country=".$country; 
     } 
    } 
    else 
    { 
     print("systemResult=Error"); 
    } 
?>

我得到的输出是

systemResult=Success&athleteName=7&email=7&time=7&timeStamp=7&country=7&athleteName=7&email=7&time=7&timeStamp=7&country=7&athleteName=4&email=4&time=4&timeStamp=4&country=4&athleteName=4&email=4&time=4&timeStamp=4&country=4&athleteName=G&email=G&time=G&timeStamp=G&country=G&athleteName=G&email=G&time=G&timeStamp=G&country=G&athleteName=n&email=n&time=n&timeStamp=n&country=n&athleteName=n&email=n&time=n&timeStamp=n&country=n&athleteName=2&email=2&time=2&timeStamp=2&country=2&athleteName=2&email=2&time=2&timeStamp=2&country=2&athleteName=I&email=I&time=I&timeStamp=I&country=I&athleteName=I&email=I&time=I&timeStamp=I&country=I

可以看出，我得到的输出是不是有什么是在数据库中的表。我越来越奇怪的价值观。我究竟做错了什么？

答

你并不需要使用每个在你的情况，如果是这样，只是打印$的数据，尽量去除foreach循环，如果你想获得的所有记录，然后，使用时：

while($data = mysql_fetch_array($query)) 
    { 
     $athleteName = $data["athleteName"]; 
     $email = $data["email"]; 
     $time = $data["time"]; 
     $timeStamp = $data["timeStamp"]; 
     $country = $data["country"]; 

     print "&athleteName=" . $athleteName; 
     print "&email=" . $email; 
     print "&time=".$time; 
     print "&timeStamp=".$timeStamp; 
     print "&country=".$country; 
    }

感谢，此代码的工作。 – 2013-03-10 11:12:30

答

尝试

while($data = mysql_fetch_array($query)) { 
    $athleteName = $data["athleteName"]; 
    //...

获取数据，没有得到正确的数据

相关推荐