<?php
    $username = "db_smap";
    $password = "fsdvsdcsdcsdcsd";
    $hostname = "mysql.ukraine.com.ua";

    //connection to the database
    $dbhandle = mysql_connect($hostname, $username, $password)
     or die("Unable to connect to MySQL");
    echo "Connected to MySQL<br>";

    //select a database to work with
    $selected = mysql_select_db("lemon00_smap",$dbhandle)
      or die("Could not select DB");

    //execute the SQL query and return records
    $result = mysql_query("SELECT id, alias, catid, created FROM pvj5q_k2_items WHERE created LIKE '%2016%'");


    //Нужно получить еще алиас категории
    //mysite.com/news/[site_categories|alias]/[site_posts|ID]-[site_posts|alias]
    //fetch tha data from the database
    while ($row = mysql_fetch_array($result)) {
       echo "http://mysite.com/news/".$row{'id'}."-".$row{'alias'}."<br>" ;
    }


    //close the connection
    mysql_close($dbhandle);
?>