$sql = "SELECT * FROM vtiger_account inner join vtiger_troubletickets on vtiger_troubletickets.parent_id = vtiger_account.accountid where vtiger_troubletickets.ticketid=?";
$result = $adb->pquery($sql, array($recordId));
$customername = $adb->query_result($result,0,'accountname');
$customerphone = $adb->query_result($result,0,'phone');
Right now the above code works. However instead of running the query twice is there a way to throw that into an array in 1 query. I am not proficient in vtiger and adb.