function getTableJoinField($table)
{
$query = new MysqlQuery();
$fields = $query->describe($table);
$field_name = '';
foreach ($fields as $field) {
if ($field['Field'] == 'name') {
return 'name';
}
if ($field_name == '' && $field['Field'] != 'id' && preg_match('/_id$/', $field['Field']) == 0) {
$field_name = $field['Field'];
}
}
return $field_name;
}
