This works - save as sitemap.php

Code:
    <?php
    echo "<?xml version='1.0' encoding='iso-8859-1'?>";
    echo "<urlset xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">";

    // hostname on which MySQL is (usally localhost)
    $dbhost = "localhost";
    // Database name
    $dbname = "";
    // Username
    $dbuser = "";
    // Password
    $dbpass = "";

    // mysql_connect() fnction
    $conn = mysql_connect($dbhost,$dbuser,$dbpass)
    or die("Unable to connect to MySQL.");

    // mysql_select_db() function
    mysql_select_db($dbname,$conn)
    or die("Unable to connect to Database $dbname");

    $sql = "Select  VID, title, description, adddate, flvdoname, duration from video where approve=1 and active=1";

    // execute SQL Command
    $res = mysql_query($sql,$conn)
    or die( "Error: " . mysql_error() );

    // Retrieve Results
    while ($info = mysql_fetch_row($res)) {
    $SefUrl=strtolower(preg_replace("/[^a-zA-Z0-9]+/","_", $info[1]));

    echo "<url><loc>http://www.site.com/video/".$info[0]."/".$SefUrl."/</loc></url>";
    
    } 
    echo "</urlset>";

    // mysql_close() function
    mysql_close($conn);
    ?>