好吧,我的代码有问题,但我找不到问题。当我使用我的代码时,我得到了这个错误:
警告:array_multsort()[function.array multisort]:阵列大小在第1506行的/home/sigesca1/public_html/hiscores/functions.ws中不一致
这是我的代码:
function findFriends($table){
include "mysql.ws";
$user = $_SESSION['username'];
$xptype = findType($table)."xp";
$query = mysql_query("SELECT u.* FROM friends uf inner join users u on uf.friend = u.username WHERE uf.user = '$user'") or die(mysql_error());
$myFriends = array();
$xpOrder = array();
WHILE($row = mysql_fetch_array($query)){
$count = count($row);
$friends = $row['username'];
$rank = findRank($friends, "$table");
$sql = mysql_query("SELECT * FROM skills WHERE playerName LIKE '$friends' ORDER BY '$xptype' DESC") or die(mysql_error());
while($skillsRow = mysql_fetch_array($sql)){
for ($i = 1; $i <= $count; $i++){
$myFriends[$friends] = array(
'xp' => $skillsRow[$xptype],
'lvl' => getLevelForXP($skillsRow[$xptype]),
'rank' => $rank,
);
$xpOrder[] = $skillsRow[$xptype];
}
array_multisort($xpOrder, SORT_NUMERIC, SORT_DESC, $myFriends);
unset($xpOrder);
foreach ($myFriends as $friend => $data){
if(dots($data['xp']) !=0){
echo '
<a name="'.$data['rank'].'"></a>
<a href="compare.ws?user1='.$friend.'" target="_self" class="row ">
<span class="columnRank">
<span>'.$data['rank'].'</span>
</span>
<span class="columnName">
<span>'.BBCode($friend).'</span>
</span>
<span class="columnLevel">
<span>'.$data['lvl'].'</span>
</span>
<span class="columnXp">
<span>'.dots($data['xp']).'</span>
</span>
</a>';
}
}
}
}
}
有人能帮我解决这个问题吗?如果你需要关于我的代码的任何其他方法,我很乐意将其添加到这个问题中。
我可以告诉您,$xpOrder
数组将是$count
元素长,而$myFriends
在经历第一个for
-循环后将是一个元素长,因为您只是一遍又一遍地覆盖$friends
元素。
只有当要进行多重排序的数组具有相同数量的元素时,才能使用array_multi-sort。基于该错误,假设$xpOrder
和$myFriends
具有导致该错误的不同数量的元素是有效的。
只需对两个数组进行print_r
,并尝试查看是否可以找出差异发生的位置。
检查此代码是否有效:
function findFriends($table){
include "mysql.ws";
$user = $_SESSION['username'];
$xptype = findType($table)."xp";
$query = mysql_query("SELECT u.* FROM friends uf inner join users u on uf.friend = u.username WHERE uf.user = '$user'") or die(mysql_error());
$myFriends = array();
$xpOrder = array();
WHILE($row = mysql_fetch_array($query)){
$count = count($row);
$friends = $row['username'];
$rank = findRank($friends, "$table");
$sql = mysql_query("SELECT * FROM skills WHERE playerName LIKE '$friends' ORDER BY '$xptype' DESC") or die(mysql_error());unset($myFriends);
while($skillsRow = mysql_fetch_array($sql)){
unset($myFriends);
for ($i = 1; $i <= $count; $i++){
$myFriends[] = array(
'friend' => $friends,
'xp' => $skillsRow[$xptype],
'lvl' => getLevelForXP($skillsRow[$xptype]),
'rank' => $rank,
);
$xpOrder[] = $skillsRow[$xptype];
}
array_multisort($xpOrder, SORT_NUMERIC, SORT_DESC, $myFriends);
unset($xpOrder);
foreach ($myFriends as $data){
if(dots($data['xp']) !=0){
echo '
<a name="'.$data['rank'].'"></a>
<a href="compare.ws?user1='.$data['friend'].'" target="_self" class="row ">
<span class="columnRank">
<span>'.$data['rank'].'</span>
</span>
<span class="columnName">
<span>'.BBCode($data['friend']).'</span>
</span>
<span class="columnLevel">
<span>'.$data['lvl'].'</span>
</span>
<span class="columnXp">
<span>'.dots($data['xp']).'</span>
</span>
</a>';
}
}
}
}
}