Thread

Hi,

I have a custom field in a channel from whom i have to retrieve the values to make a list. The custom field host a limited set of values but these values can repeat across entries (example: 10 post with value of Connecticut, 13 post with value of Minnesota and so on).

The field must be a input text (no pre-filled dropdowns and the likes) so when i retrieve the value with weblog:entries I have each value repeatedly shown.

How (if possible) can i tell to the engine to show each value only once? 

Thanks

a custom SQL query leaps immediately to mind:

SELECT DISTINCT
    field_id_XX AS my_custom_field
FROM
    exp_weblog_data
WHERE
    weblog_id = 2
ORDER BY field_id_XX ASC;

where the XX in field_id_XX is replace by the proper field_id for your custom field, using the proper value for weblog_id, and changing my_custom_field to whatever is appropriate.

ender, thank you very much for your istant support!