private function _getLinkProperties($joinTable)
{
if (! isset(self::$_JoinTableProperties))
{
$query = "SELECT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME LIKE '%#%' AND COLUMN_NAME != 'pk1' AND COLUMN_NAME != 'pk2'";
$result = mysql_query($query);
self::$_JoinTableProperties = array(); // prevent isset() test above from occurring again
while ($row = mysql_fetch_assoc($result))
{
$table = $row['TABLE_NAME'];
$column = $row['COLUMN_NAME'];
self::$_JoinTableProperties[$table][$column] = $column;
}
}
return self::$_JoinTableProperties[$joinTable];
}
