I would like to retrieve and display values in the Database (SQL server). The only problem is that multiple records have the same value in the column. I would basically like cycle through the column and to display a list of all unique values and omit identicals.
$result = $DB->get_records_sql('SELECT column_name FROM table_name WHERE **cycle through column and list all values without duplicates**')
Any help is much appreciated!