Dynamic Menu Help
been trying to sort out a dynamic menu created with data bridge, in that the menu should only display one of the values.
Basically I have a list of currency's by country and language.
the menu provides currency's only, but all of them.
Taking into account that I need the ID for the drop menu as it is inserted to the DB once selected, and the currency is displayed in the menu which is what should be distinct from other values.
I have tried the following two options and am now at a loss.....
"SELECT DISTINCT language_currency, language_ID FROM per_language ORDER BY language_currency ASC";
= This provides me all ID as a distinct value, which I don't want, i want currency not the ID.
"SELECT language_currency, language_ID FROM per_language ORDER BY language_currency ASC GROUP BY language_currency";
= this one gives me an SQL error, but any guides I have found even ideas here have suggested this, with no result.
any help would be appreciated.
thanks in advance