Hi
I have been testing a search/filter field which is created by concat, using the php plugin onload. The fields are a regular text field ('factory_name') and a database join field ('country_retest'). The following code is sort of working:
$myDb = JFactory::getDbo();
$myQuery = $myDb->getQuery(true);
$myQuery->update('factory_table')->set('php_testing = concat(factory_name, \' \',country_retest)') ;
$myDb->setQuery($myQuery);
$myDb->execute();
However it shows the ID of the database join element, not the label/value. I think I need to access the value of the field and have tried to do so by following the wiki, but I seem to keep running into error messages.
If someone could kindly show me how to access the value correctly (not the ID) I would be very greatful.
Kind Regards
I have been testing a search/filter field which is created by concat, using the php plugin onload. The fields are a regular text field ('factory_name') and a database join field ('country_retest'). The following code is sort of working:
$myDb = JFactory::getDbo();
$myQuery = $myDb->getQuery(true);
$myQuery->update('factory_table')->set('php_testing = concat(factory_name, \' \',country_retest)') ;
$myDb->setQuery($myQuery);
$myDb->execute();
However it shows the ID of the database join element, not the label/value. I think I need to access the value of the field and have tried to do so by following the wiki, but I seem to keep running into error messages.
If someone could kindly show me how to access the value correctly (not the ID) I would be very greatful.
Kind Regards