Translating genres in Kodi

<?php
require ('init/html_header.inc.php');
require ('init/main_menu.inc.php');

# CLEANUP MOVIE GENRES (DUTCH  TO ENGLISH ONLY)
# -------------------------------------------------------
$genres[] = array('Actie'          , 'Action');
$genres[] = array('Avontuur'       , 'Adventure');
$genres[] = array('Avonturen'      , 'Adventure');
$genres[] = array('Animatie'       , 'Animation');
$genres[] = array('Komedie'        , 'Comedy');
$genres[] = array('Documentaire'   , 'Documentary');
$genres[] = array('Familie'        , 'Family');
$genres[] = array('Fantasie'       , 'Fantasy');
$genres[] = array('Historisch'     , 'History');
$genres[] = array('Misdaad'        , 'Crime');
$genres[] = array('Muziek'         , 'Music');
$genres[] = array('Mysterie'       , 'Mystery');
$genres[] = array('Oorlog'         , 'War');
$genres[] = array('Muziek'         , 'Music');
$genres[] = array('Romantiek'      , 'Romance');
$genres[] = array('Romantisch'     , 'Romance');

$genres[] = array('Science Fictie'  , 'Science Fiction');
$genres[] = array('Sciencefiction'  , 'Science Fiction');
$genres[] = array('Science-Fiction' , 'Science Fiction');

$genres[] = array('Sport'           , 'Sports Film');

# ========================================================

// dump ($genres);
echo '<h3>Trimming genres into English</h3>';
echo '<hr style="color: gray;">';
echo '<br />';

foreach ($genres AS $key => $value)
{
    if (is_array($value))
    {
        $genre_nl = $value[0];
        $genre_en = $value[1];

        echo '<pre>';

            # DUTCH GENRE
            $query = "  SELECT
                            genre_id, name
                        FROM
                            genre
                        WHERE
                            name = '".$genre_nl."'
                        ";
            $result = do_query($query, 'video', 'Getting all genres');
            while ($row = $result->fetch_assoc())
            {
                $row = mysql_fetch_assoc($result);
                $genre_nl_id = $row['genre_id'];
                $genre_nl_name = $row['name'];
                echo ('<b>NL</b>: '.$genre_nl_id.'/'.$genre_nl_name);
                echo ' | ';
            }

            # ENGLISH GENRE
            $query = "  SELECT
                            genre_id, name
                        FROM
                            genre
                        WHERE
                            name = '".$genre_en."'
                        ";
            $result = do_query($query, 'video', 'Getting a genre');
            if ($result->num_rows == 1)
            {
                $row = $result->fetch_assoc();
                $genre_en_id = $row['genre_id'];
                $genre_en_name = $row['name'];
                echo ('<b>EN</b>: '.$genre_en_id.'/'.$genre_en_name);
                echo ' | ';
            }


            # REPLACE GENRE VALUES IN GENRE-LINK TABLE
            $query = "UPDATE genre_link SET genre_id=".$genre_en_id." WHERE genre_id=".$genre_nl_id;
            $result = do_query($query, 'video', 'Updating genre-link');
            $aantal = $result->affected_rows;
            echo ('Aantal: '.$aantal);

        echo '</pre>';
    }
}
?>