";
foreach($modules_mappings as $module)
{
$conditionsql = " WHERE {$module['tms_uid_field']} = '" . escape_check($tmsid) . "'";
$tmscountsql = "SELECT Count(*) FROM {$module['module_name']} {$conditionsql};";
$tmscountset = odbc_exec($conn, $tmscountsql);
$tmscount_arr = odbc_fetch_array($tmscountset);
$resultcount = count($tmscount_arr);
if($resultcount == 0)
{
return $lang["tms_link_no_tms_data"];
}
$tmssql = "SELECT * FROM {$module['module_name']} {$conditionsql};";
echo "Query: " . $tmssql . "
";
$tmsresultset = odbc_exec($conn, $tmssql);
for($r = 1; $r <= $resultcount; $r++)
{
$tmsdata = odbc_fetch_array($tmsresultset, $r);
if(is_array($tmsdata))
{
foreach($tmsdata as $name=>$value)
{
echo escape($name . " : " . ($value ?? '[NULL]')) . "
";
}
}
else
{
echo "No data returned";
}
}
}
echo "";
}
odbc_close($conn);
include "../../../include/footer.php";