选择“查询中需要下一行”

所以我的游戏里有一个攻击系统，玩家使用他们购买的武器，可以互相攻击。好吧，他们也有与他们战斗的朋友，你在游戏中升级。对于每个级别，您可以与另外5个人战斗，所以它是这样的： 等级 * 5 = 可用的生物 例如：我是 5 级，有 100 个朋友;我可以和其中的25个朋友战斗，每个类别使用25种武器。这是一个截图，所以说在近战类别中，我有 10 把刀、5 根棒球棒和 10 把斧头。我将如何设置它以使用最好的攻击武器？这是我目前用来限制和选择 1 种武器的代码：

if($level >= 100) {
if($mob_size >=500) {
$a_melee_avail = 500 + $hired_guns; 
}
else {  
$a_melee_avail = $total_mob;    
    }
}
if($level < 100) {
if($mob_size > $level * 5) {    
$a_melee_avail = $level * 5; 
}
else {
$a_melee_avail = $mob_size; 
    }
}
$check_a_melee = mysql_query("SELECT * FROM weapons WHERE owner_id=".$id." AND type='melee' AND owned>=".$a_melee_avail." LIMIT 1");
$check_a_mel_info = mysql_fetch_array($check_a_melee);
$a_mel_limit_plus1 = ($check_a_mel_info['id'] + 1);
// Checking melee owned
if(mysql_num_rows($check_a_melee) == 0) {
$a_get_melee = mysql_query("SELECT * FROM weapons WHERE owner_id=".$id." AND type='melee' AND owned<=".$a_melee_avail." ORDER BY attack DESC LIMIT 1"); 
}
if(mysql_num_rows($check_a_melee) == 1) {
$a_get_melee = mysql_query("SELECT * FROM weapons WHERE owner_id=".$id." AND type='melee' AND owned>=".$a_melee_avail." ORDER BY attack DESC LIMIT 1");     
}
$a_melee = mysql_fetch_array($a_get_melee);
$a_melee_name = $a_melee['name'];
$a_melee_attack = $a_melee['attack'];
$a_melee_owned = $a_melee['owned'];
// Checking Availability
if($a_melee_owned >= $a_melee_avail) {
$a_melee_used = $a_melee_avail; 
}
if($a_melee_owned < $a_melee_avail) {
$a_melee_used = $a_melee_owned; 
}
$a_melee_damage = $a_melee_attack * $a_melee_used;

但是，只需根据攻击选择1种最佳武器，我如何将其设置为他们使用所有可用武器的位置？