blue-mouse
Member
Hi,
I have urgent problem to solve how to search/filter on my list1 by field that is databasejoin-multi-select-dropdown - it is mentioned in other thread. So this doesn't work actually.
The one way i try to find solution is copy values from field1={ccjom_cc_szkolenia___multipersons_raw} - databasejoin-multiselect-dropdown to field2={ccjom_cc_szkolenia___test1} that is textarea, this if i do this should solve problem with searching/filtering.
I try php plugin for my form1 but this does't work, this returns NULL.
I don't know why this doesn't returns values so i did something similar in email plugin for form1 also and this returns values.
My code is:
$db =& JFactory::getDBO();
$recipient2 = '{ccjom_cc_szkolenia___multipersons_raw}';
$query = "SELECT GROUP_CONCAT(`email`) FROM `ccjom_users` WHERE `id` IN ($recipient2)";
$db->setQuery($query);
$result = $db->loadResult();
var_dump($result);
exit;
//return $result;
$query = "UPDATE `ccjom_cc_szkolenia` SET `test1`=$result";
$db->setQuery($query);
$db->query();
I have code for email plugin very similar that returns emails values:
$db =& JFactory::getDBO();
$recipient2 = '{ccjom_cc_szkolenia___multipersons_raw}';
$query = "SELECT GROUP_CONCAT(`email`) FROM `ccjom_users` WHERE `id` IN ($recipient2)";
$db->setQuery($query);
$result = $db->loadResult();
//var_dump($result);
return $result;
Can i get any tip what is wrong with my php code and idea with copying values from field1 to field2?
I have urgent problem to solve how to search/filter on my list1 by field that is databasejoin-multi-select-dropdown - it is mentioned in other thread. So this doesn't work actually.
The one way i try to find solution is copy values from field1={ccjom_cc_szkolenia___multipersons_raw} - databasejoin-multiselect-dropdown to field2={ccjom_cc_szkolenia___test1} that is textarea, this if i do this should solve problem with searching/filtering.
I try php plugin for my form1 but this does't work, this returns NULL.
I don't know why this doesn't returns values so i did something similar in email plugin for form1 also and this returns values.
My code is:
$db =& JFactory::getDBO();
$recipient2 = '{ccjom_cc_szkolenia___multipersons_raw}';
$query = "SELECT GROUP_CONCAT(`email`) FROM `ccjom_users` WHERE `id` IN ($recipient2)";
$db->setQuery($query);
$result = $db->loadResult();
var_dump($result);
exit;
//return $result;
$query = "UPDATE `ccjom_cc_szkolenia` SET `test1`=$result";
$db->setQuery($query);
$db->query();
I have code for email plugin very similar that returns emails values:
$db =& JFactory::getDBO();
$recipient2 = '{ccjom_cc_szkolenia___multipersons_raw}';
$query = "SELECT GROUP_CONCAT(`email`) FROM `ccjom_users` WHERE `id` IN ($recipient2)";
$db->setQuery($query);
$result = $db->loadResult();
//var_dump($result);
return $result;
Can i get any tip what is wrong with my php code and idea with copying values from field1 to field2?