I have a database that contains a series of entries that have a category. I want the category names to be displayed on a webpage so that I can make them into hyperlinks. There are several instances of the category names in the database but I only want each category name to appear on the web page once. But at the moment the categories are being displayed every time they appear in the database as below.
category 1
category 2
category 5
category 4
category 3
category 1
whereas I only want each category displayed once such as
category 1
category 2
category 5
category 4
category 3
What is the best possible way to do this in coldfusion?
category 1
category 2
category 5
category 4
category 3
category 1
whereas I only want each category displayed once such as
category 1
category 2
category 5
category 4
category 3
What is the best possible way to do this in coldfusion?