10 years ago
3
Topic
Good afternoon. ask for help.I have articles that have field CITY.I want to search, where the user can select the city and see all the articles from this city.City box I made as a text. am submitting data from the admin area, they appear in the database.I did DYNAMIC field and it shows all the values of the City box. But if I have a few articles where it is registered in one city DYNAMIC I have shown some of the same cities.how can we improve the situation? to show only one occurrence of the city.
Get a VIP membership
175 Posts
webcastor
10 years ago
1
Level 1
You might try SELECT DISTINCT fieldName ...
10 years ago
0
Level 2
I'm sorry, I did not understand what to do
175 Posts
webcastor
10 years ago
0
Level 1
In your Select Dynamic field definition set your Query to Free, and input your SQL query

Naturally, you would use some condition in where or lose the where part all together.
This is valid if you have defined your city field in #_content table, otherwise substitute with table name #__cck_store_item_content or which ever table is your city field stored in.
Get a Book for SEBLOD