if (empty($pk)) {
echo '1';
exit;
}
// load table
$tableObj = new Table($table);
if ($debug) {
echo '<pre>' . "\n";
}
echo '{' . "\n\n";
echo ' "rowPk": \'' . $pk . '\',' . "\n";
$result = mysql_query("SELECT * FROM {$table} WHERE {$pk} = {$rowPk}");
if (mysql_num_rows($result) >= 1) {
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$j = 1;
foreach ($tableObj->getFieldsArray() as $fieldName => $fieldType) {
$directAssocMatchArray = $tableObj->getDirectAssocMatch($fieldName);
$value = $row[$fieldName];
// true / false
if ($fieldType == 'tinyint(1)') {
if ($value == '1' || $value == '0') {
$value .= $value == '1' ? ' <span style="color:purple;">True</span>' : ' <span style="color:purple;">False</span>';
}
// direct association
} elseif (count($directAssocMatchArray) >= 1) {
$strMaxLen = 30;
foreach ($directAssocMatchArray as $matchedTable) {
if (!empty($matchedTable)) {
$result2 = mysql_query("SELECT * FROM {$matchedTable} WHERE {$fieldName} = '" . mysql_real_escape_string($value) . "'");
if (mysql_num_rows($result2) >= 1) {
$row2 = mysql_fetch_array($result2, MYSQL_ASSOC);
