function audevo_artists_directory_shortcode($atts) {
$current_letter = isset($_GET[‘letter’]) ? strtoupper(sanitize_text_field($_GET[‘letter’])) : ‘A’;
$letters = range(‘A’, ‘Z’);
global $wpdb;
$all_artists = $wpdb->get_col(”
SELECT DISTINCT meta_value
FROM {$wpdb->postmeta}
INNER JOIN {$wpdb->posts} ON {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id
WHERE meta_key = ‘_artist_name’
AND meta_value != ”
AND {$wpdb->posts}.post_status = ‘publish’
AND {$wpdb->posts}.post_type = ‘download’
ORDER BY meta_value ASC
“);
$filtered = array_filter($all_artists, function($name) use ($current_letter) {
return strtoupper(substr($name, 0, 1)) === $current_letter;
});
ob_start();
?>