function get_albums() {

    $dbhost = "localhost";
    $dbuser = "root";
    $dbpassword = "";
    $dbdatabase = "visualupload";

    $link = mysqli_connect($dbhost, $dbuser, $dbpassword, $dbdatabase);

    $albums = array();
    $albums_query = "select 'albums.album_id','albums.timestamp','albums.name', LEFT('albums.description', 50) as 'description', COUNT('images.image_id') as 'image_count'
        FROM 'albums'
        LEFT JOIN 'images'
        ON 'albums.album_id' = 'images.album_id'
        WHERE 'albums.user_id' = " . $_SESSION['user_id'] . "
            GROUP BY 'albums.album_id'
            ";

    $result = mysqli_query($link, $albums_query) or die(mysqli_error($link));

    while ($albums_row = mysqli_fetch_assoc($result)) {
        $albums[] = array(
            'id' => $albums_row['album_id'],
            'timestamp' => $albums_row['timestamp'],
            'name' => $albums_row['name'],
            'description' => $albums_row['description'],
            'count' => $albums_row['image_count']
        );
    }

    return $albums;
}

function create_album($album_name, $album_description) {
    $album_name = mysql_real_escape_string(htmlentities($album_name));
    $album_description = mysql_real_escape_string(htmlentities($album_description));

    mysql_query("INSERT INTO 'albums' VALUES ('', '" . $_SESSION[user_id] . "', UNIX_TIMESTAMP()','$album_name','$album_description')");
    mkdir('uploads/' . mysql_insert_id(), 0744);
    mkdir('uploads/thumbs/' . mysql_insert_id(), 0744);
}