Dear Community,
I am trying to open the Contact DB table and also show all the tags that are listed for each contact in the same pull.
I can do it but because I am opening a second connection it is taking too long and the code is timing out.
Here is a base of my code:
$query = array(‘LastName’ => ‘Janedo’);
$CntCompany = $app->dsCount(“Contact”,$query);
$returnFields = array(‘Id’,‘email’, ‘Company’,‘FirstName’, ‘LastName’, ‘Phone1’, ‘Phone2’, ‘StreetAddress1’, ‘StreetAddress2’, ‘City’, ‘PostalCode’, ‘_PenStartDate’, ‘ContactNotes’);
$contacts = $app->dsQuery(“Contact”,1000,0,$query,$returnFields);
foreach ($contacts as $key => $row) {
$CompanyName[$key] = $row[‘Company’];
}
array_multisort($CompanyName, SORT_ASC, $contacts);
foreach($contacts as $item) {
//Open second conection to get group id
foreach ($contacts as $key => $row) {
$GroupId[$key] = $row[‘GroupId’];
}
array_multisort($GroupId, SORT_ASC, $contacts);
foreach($contacts as $item) {
$GroupId = $item['GroupId'];
echo($GroupId);
}
}
My question is, is there anyway search 2 database tables in one pull?
Thanks Dan