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);