<?php
header('Content-Type: text/xml');

require '_functions.php';
require '_db.php';

$res = mysqli_query( $db, "
        SELECT * FROM neighborhoods as n ORDER BY n.slug ASC
    ");

echo '<?xml version="1.0" encoding="UTF-8"?>';
echo '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';
echo '<url><loc>https://waldronelectric.com/</loc><lastmod>2022-11-07</lastmod></url>';

    if ($res->num_rows > 0) {
        while($c = $res->fetch_assoc()) {
            echo '<url><loc>https://waldronelectric.com/'.$c['slug'].'/</loc><lastmod>2022-11-07</lastmod></url>';
        }
    }


echo '</urlset>';
?>