<?php
$conn = new mysqli('localhost', 'will_refer', 'will#123qwe!', 'will_refer');
$conn->set_charset('utf8');
// Check connection

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
$result = $conn->query('SELECT building_id,mansion_id,floor,underground,company_id FROM articles WHERE mansion_id IS NOT NULL');
if($result->num_rows > 0) {
    echo 'Count Room: '.$result->num_rows.'<br>';
    $i = 0;
    while($row = mysqli_fetch_object($result)) {
        $mansion = $conn->query('SELECT floor,underground FROM articles WHERE company_id = '.$row->company_id.' AND floor IS NOT NULL AND building_id = '.$row->mansion_id);
        if($mansion->num_rows > 0){
            $mon = $mansion->fetch_assoc();
            if($row->floor != $mon['floor']){
                $i++;
                if(!empty($mon['underground'])){
                    $sql = 'UPDATE articles SET floor = '.$mon['floor'].', underground = '.$mon['underground'].' WHERE company_id = '.$row->company_id.' AND building_id = '.$row->building_id;
                }else{
                    $sql = 'UPDATE articles SET floor = '.$mon['floor'].' WHERE company_id = '.$row->company_id.' AND building_id = '.$row->building_id;
                }

                if ($conn->query($sql) === FALSE){
                    echo "Error: " . $sql . "<br>" . $conn->error;
                }
            }
        }

    }
    echo $i;
}
?>