[Stinged]

I rarely use non threaded queries, but I think you need to store the result to be able to use cache_ functions.
Try this:

Code:

mysql_GetUserNameFromTable(userid) 
{ 
    new query[50];
    printf("%d", userid); 
    mysql_format(dbhandle, query, sizeof (query), "SELECT * FROM spieler WHERE id = %d", userid); 
	
    new Cache:result = mysql_query(dbhandle, query); 
    cache_get_field_content(0, "name", query, dbhandle); 
    cache_delete(result);
	
    printf("%s - %s",query, date(gettime())); 
    return query; 
}