HELP

'use strict';
var express = require('express');
var path = require('path');
var ejs = require('ejs');
var mysql = require('mysql')

var routes = require('./routes/index');
var users = require('./routes/users');

var app = express();

// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'html');
app.engine('html', ejs.renderFile);
app.use(express.static('public'))

app.use('/', routes);
app.use('/users', users);

var connection = mysql.createConnection({
    host: 'localhost',
    username: 'root',
    password: 'XD',
    database: 'sample'
});

connection.connect();

app.get('/', function (req, res)
{
    connection.query('SELECT * FROM users', function (e, r, f) {
        if (!!error)
        {
            Console.log('Error in the database')
        }
        else
        {
            console.log(r[0].name);
        }
    });
})

// catch 404 and forward to error handler
app.use(function (req, res, next) {
    var err = new Error('Not Found');
    err.status = 404;
    next(err);
});

// error handlers

// development error handler
// will print stacktrace
if (app.get('env') === 'development') {
    app.use(function (err, req, res, next) {
        res.status(err.status || 500);
        res.render('500', {
            message: err.message,
            error: err
        });
    });
}

// production error handler
// no stacktraces leaked to user
app.use(function (err, req, res, next) {
    res.status(err.status || 500);
    res.render('500', {
        message: err.message,
        error: {}
    });
});


module.exports = app;