var http = require('http');
var sys = require("sys");

function lol()
{
    var mysql = require('mysql');
    var TEST_DATABASE = 'finnalt';
    var client = mysql.createClient({
      user: 'root',
      password: 'lal',
    });

    client.query('USE '+TEST_DATABASE);
    client.query(
        'SELECT id, title, url FROM ad order by id desc limit 1',
        function selectCb(err, results, fields)
        {
            client.end();
            console.log(results[0]["title"]);
            return results[0]["title"];
        }
    );


}

http.createServer(function (request, response) {

    response.writeHead(200, {'Content-Type': 'text/plain; charset="utf-8"'});
    response.write('Hello world');
    response.write('\n' + lol()); // write undefined :(
    response.end();

}).listen(8000);

sys.puts("heia :)")