Не работает php-скрипт для выгрузки данных в XML-файл. Просьба глянуть что не так

<?php
require_once ('connect.php');
 
$qs = "SELECT * FROM `vacancies` ORDER BY `created` DESC LIMIT 10";
$q = mysql_query($qs);
 
 
$xml = new DOMDocument('1.0', 'windows-1251');
 
$jobs = $xml->appendChild($xml->createElement('jobs'));
 
while ($row=@mysql_fetch_array($q))
{
$job = $jobs->appendChild($xml->createElement('job'));
$job->setAttribute("id", $row['id']);
 
$speciality = $row['speciality'];
$element = $xml->createElement('name', "{$speciality}");
$job->appendChild($element);
}
 
echo $xml->saveXML();
?>

print_r($row);

<?php
 
/**
 * @param array[] $data
 * @param string  $encoding
 * @return string
 */
function xmlCreate(array $data, $encoding = 'utf-8') {
    /** @var DOMDocument $xml */
    $xml = new DOMDocument('1.0', $encoding);
    /** @var DOMElement $jobs */
    $jobs = $xml->createElement('jobs');
    /** @var array $row */
    foreach ($data as $row) {
        /** @var DOMElement $job */
        $job = $xml->createElement('job');
        $job->setAttribute('id', $row['id']);
        /** @var DOMElement $name */
        $name = $xml->createElement('name', $row['speciality']);
        $job->appendChild($name);
        $jobs->appendChild($job);
    }
    $xml->appendChild($jobs);
    return $xml->saveXML();
}
 
$test_data = [
    ['id' => 1, 'speciality' => "some\ndata" ],
    ['id' => 2, 'speciality' => "some\ndata" ],
    ['id' => 3, 'speciality' => "some\ndata" ],
    ['id' => 4, 'speciality' => "some\ndata" ],
    ['id' => 5, 'speciality' => "some\ndata" ],
    ['id' => 6, 'speciality' => "some\ndata" ],
];
 
$encoding = 'windows-1251';
 
/** @var mysqli $db */
$db = new mysqli('localhost', 'user', 'pass', 'database');
$db->set_charset($encoding);
 
$sql = 'SELECT * FROM `vacancies` ORDER BY `created` DESC LIMIT 10';
 
/** @var mysqli_result $q */
$q = $db->query($sql);
$data = $q->fetch_all(MYSQLI_ASSOC);
$q->close();
 
$xml = xmlCreate($data, $encoding);
 
echo $xml;
 
$db->close();