I connected external database (Mysql) to PM successfully. (Encode is utf8-UTF-8 Unicode)
I am going to use the mentioned database in order to get the products' names in my daynaform.
I used dropdown for my goal, I did the following steps:
1) I selected my special DB connection
2)in SQL part, I used this code to get the names of products: SELECT products_name FROM products
The aforementioned code works properly in phpmyadmin, but PM can not appear the list of products' names in my dropdown! It's worth mentioning that, in the dropdown some rows are added, but the names can not be appeared. (As seen in the attached image)
I would be appreciated if you could help me to solve my problem