循环遍历数组并检查num是否低于前一个数字.
$data数组的示例:
$data = array(
[0] => array('id' => 9267399, 'code' => '5D:148', 'num' => 64),
[1] => array('id' => 9267398, 'code' => '5D:186', 'num' => 71)
);
–
$array_to_add = array();
foreach($data AS $val) {
if(array_key_exists($val['code'], $array_to_add)) {
if((int) $val['num'] < (int) $array_to_add[$val['code']]['num']) { // Check if num is lower than the previous one
$array_to_add[$val['code']] = $val; // If yes, overwrite code key with new values
}
} else {
$array_to_add[$val['code']] = $val; // Add values to array if code doesn't exist in array_to_add
}
}
var_dump($array_to_add); // ARRAY TO ADD IN DATABASE
foreach($array_to_add AS $val) {
mysql_query("UPDATE table SET id = ".mysql_real_escape_string($val['id']).", num = ".mysql_real_escape_string($val['num'])." WHERE code = '".mysql_real_escape_string($val['code'])."' ");
}
?>
提示:查看PDO和mysqli以更好地使用mysql查询.