$wpdb->insert(
				$genres_table,
				array(
					'ctp_genero' => $ctp_genero,
					'ctp_padre' => $ctp_padre
				)
			);

			echo '<p>genre added successfully</p>';
			echo '<script>window.location.href = "?page=album_collection_genres";</script>';
		}

	// Display genres with sorting links
	$genres = $wpdb->get_results("SELECT * FROM $genres_table ORDER BY $orderby $order");

	// Add a wrapper div with horizontal scrolling
	$headerurl = '<a href="?page=album_collection_genres&orderby=';
	echo '<div class="db-wrapper">';
	echo '<table class="wp-list-table widefat fixed striped">';

	echo '<thead class="db-header">
			<tr class="db-small">
				<th class="db-heading db-blue">' . $headerurl . 'id&order=' . (($orderby == 'id' && $order == 'ASC') ? 'DESC' : 'ASC') . '">id</a></th>
				<th class="db-heading db-purple">' . $headerurl . 'ctp_genero&order=' . (($orderby == 'ctp_genero' && $order == 'ASC') ? 'DESC' : 'ASC') . '">genre</a></th>
				<th class="db-heading db-purple">' . $headerurl . 'ctp_padre&order=' . (($orderby == 'ctp_padre' && $order == 'ASC') ? 'DESC' : 'ASC') . '">parent</a></th>
				<th class="db-heading db-blue">acción</th>
			</tr>
		</thead>';

	echo '<tbody>';
	foreach ($genres as $genre) {
		echo '<tr data-id="' . esc_attr($genre->id) . '">';
		echo '<td class="editable db-row" data-column="id">' . esc_html($genre->id) . '</td>';
		echo '<td class="editable db-row" data-column="ctp_genero">' . esc_html($genre->ctp_genero) . '</td>';
		echo '<td class="editable db-row" data-column="ctp_padre">' . esc_html($genre->ctp_padre) . '</td>';
		echo '<td class="db-row"><a href="?page=album_collection_genres&edit=' . esc_attr($genre->id) . '">edit</a> | ';
		echo '<a href="' . wp_nonce_url("?page=album_collection_genres&delete=" . esc_attr($genre->id), 'delete_genre_' . esc_attr($genre->id)) . '" onclick="return confirm(\'This action is irreversible. Are you sure you want to delete this genre?\');">delete</a></td>';
		echo '</tr>';
	}
	echo '</tbody>';
	echo '</table>';
	echo '</div>'; // Close the wrapper div

	// Add JavaScript for editable fields and AJAX request
	echo '<script type="text/javascript">';
	echo 'var updateGenreNonce = "' . $ajax_nonce . '";';
	echo 'jQuery(document).ready(function($) {';
	echo '$(".editable").on("dblclick", function() {';
	echo '	var $this = $(this);';
	echo '	var currentText = $this.text();';
	echo '	var column = $this.data("column");';
	echo '	var id = $this.closest("tr").data("id");';
	echo '	$this.html("<textarea class=\'db-window\' rows=\'3\' cols=\'20\' >" + currentText + "</textarea>");';
	echo '	$this.find("textarea").focus().on("blur", function() {';
	echo '		var newValue = $(this).val();';
	echo '		$this.html(newValue);';
	echo '		$.ajax({';
	echo '			url: ajaxurl,';
	echo '			method: "POST",';
	echo '			data: {';
	echo '				action: "update_genre_field",';
	echo '				id: id,';
	echo '				column: column,';
	echo '				value: newValue,';
	echo '				_ajax_nonce: updateGenreNonce'; // Include nonce in AJAX request
	echo '			},';
	echo '			success: function(response) {';
	echo '				console.log("Input updated successfully");';
	echo '			},';
	echo '			error: function(response) {';
	echo '				console.error("Update failed");';
	echo '			}';
	echo '		});';
	echo '	});';
	echo '});';
	echo '});';
	echo '</script>';

	echo '</div>';
}

// Register the AJAX handler for updating genre fields
add_action('wp_ajax_update_genre_field', 'update_genre_field');

// Function to handle the AJAX request for updating the genre field
function update_genre_field() {
	// Verify the nonce
	check_ajax_referer('update_genre_nonce', '_ajax_nonce');

	global $wpdb;
	$genres_table = $wpdb->prefix . 'album_collection_genres';
	
	// Get the data from the AJAX request
	$genre_id = intval($_POST['id']);
	$column = sanitize_text_field($_POST['column']);
	$value = sanitize_text_field($_POST['value']);
	
	// Update the specific column in the genre table
	$wpdb->update(
		$genres_table,
		array($column => $value),
		array('id' => $genre_id)
	);
	
	// Return a success response
	wp_send_json_success('Input updated successfully');
}
?>