georgie
Member
Hello
I use a calc field to display remote data (another database). It's absolutely great, thank you Fabrik!
Now I would like to display data from another database, but in the same field (to minimize the number of fields). Is this possible?
Here my actual code fort just one remote DB (works like a charm):
I have try to just add this after my first loadResult, mais cela suffit ? faire planter la page:
Please have you an idea?
Georges
I use a calc field to display remote data (another database). It's absolutely great, thank you Fabrik!
Now I would like to display data from another database, but in the same field (to minimize the number of fields). Is this possible?
Here my actual code fort just one remote DB (works like a charm):
Code:
$prospects_email = '{prospects___email_raw}';
if (!empty($prospects_email)) {
$myDb = FabrikWorker::getDbo(false, 11);
$myQuery = $myDb->getQuery(true);
$myQuery->select("group_concat(ma_concat SEPARATOR ', ')
from (select concat(date_format(from_unixtime(prime_acymailing_urlclick.date),'%d/%m/%Y')) as ma_concat
from prime_acymailing_url inner join prime_acymailing_urlclick on prime_acymailing_url.urlid = prime_acymailing_urlclick.urlid inner join prime_acymailing_subscriber on prime_acymailing_urlclick.subid = prime_acymailing_subscriber.subid
where prime_acymailing_subscriber.email = " . $myDb->quote($prospects_email) . "
order by prime_acymailing_urlclick.date desc
limit 0,6) as alias");
$myDb->setQuery($myQuery);
$ClicHistory = $myDb->loadResult();
if (!empty($ClicHistory)) {
return 'Last clicks from <font style="color:#f38709 ; font-weight: bold">Prime-journal.online</font> on '. $ClicHistory ;
}
}
// If empty
else {
return '';
}
I have try to just add this after my first loadResult, mais cela suffit ? faire planter la page:
Code:
$myDb2 = FabrikWorker::getDbo(false, 17);
$myQuery2 = $myDb2->getQuery(true);
$myQuery2->select("group_concat(ma_concat SEPARATOR ', ')
from (select concat(date_format(from_unixtime(vcs_acymailing_urlclick.date),'%d/%m/%Y')) as ma_concat
from vcs_acymailing_url inner join vcs_acymailing_urlclick on vcs_acymailing_url.urlid = vcs_acymailing_urlclick.urlid inner join vcs_acymailing_subscriber on vcs_acymailing_urlclick.subid = vcs_acymailing_subscriber.subid
where vcs_acymailing_subscriber.email = " . $myDb2->quote($prospects_email) . "
order by vcs_acymailing_urlclick.date desc
limit 0,6) as alias");
$myDb2->setQuery($myQuery2);
$ClicHistory2 = $myDb2->loadResult();
Please have you an idea?
Georges
Last edited by a moderator: