循环打印数组时出错 - error printing array when looping over it

error printing array when looping over it

本文关键字：出错数组打印循环 | 更新日期: 2023-09-27

对不起，这个问题相对较新。在过去的一个小时里，我一直试图弄清楚为什么名为 $propname 的数组在我循环时不想打印。这是我的代码

$result = mysql_query("SELECT * FROM `player_info` WHERE `position` = 'THP'") or die(mysql_error()) ;
while($row = mysql_fetch_array($result)) //create arrays
{   
    $id[] = $row['player_id'];      
    $propName[] = $row['name'];
    $propLastName[]= $row['surname'];
}//end while
 //create variables for looping
$x = sizeof($propName);
$index = 0;
while($index < $x) //print variables
{
    echo $propName[$index];
    $index ++;
}

只需简化您的代码

$result = mysql_query("SELECT * FROM `player_info` WHERE `position` = 'THP'") or die(mysql_error()) ;
while($row = mysql_fetch_array($result)) //create arrays
{   
    echo $row['name'];
}

$result = mysql_query("SELECT * FROM `player_info` WHERE `position` = 'THP'") or             die(mysql_error()) ;
while($row = mysql_fetch_assoc($result)) //create arrays
{   
    $id = $row['player_id'];      
    echo $propName = $row['name'];
    $propLastName = $row['surname'];
}