Hi
Ive been trying to work out how to insert the value of a multiselect drop down dbjoin element from one table into another table via php. Using the php form plugin, I am currently able to insert the values (into a standard field element) along the lines of:
->set('associate = ' . $db->quote('{designer_table___styles_test_raw}'))
which returns the key values (eg 4,6,9) but I guess it needs to be returned in the right format (something like ["4","6","9"] so it can be used as a dbjoin field (it currently only shows the first value when the field is changed to a dbjoin).
I tried to decode the data first but it still just returns the values as a list of numbers.
Any help would be great.
Kind Regards
Ive been trying to work out how to insert the value of a multiselect drop down dbjoin element from one table into another table via php. Using the php form plugin, I am currently able to insert the values (into a standard field element) along the lines of:
->set('associate = ' . $db->quote('{designer_table___styles_test_raw}'))
which returns the key values (eg 4,6,9) but I guess it needs to be returned in the right format (something like ["4","6","9"] so it can be used as a dbjoin field (it currently only shows the first value when the field is changed to a dbjoin).
I tried to decode the data first but it still just returns the values as a list of numbers.
Any help would be great.
Kind Regards