<p id="instruction" style="font-size: 2em; font-family: Arial, Helveitca, Sans-serif; color: Blue; margin-bottom: 5px;">
<span style="color: Crimson; font-weight: bold;">Crtl+Click</span>
on a field you want to edit...
<small style="color:red; font-size:0.9em;">Be careful with those that have HTML content!</small>
</p>
<?php
print_a($aql_data);
elapsed('before getting cols');
$column_name = $tablename . "_id";
$sql = "SELECT\n a.table_name\n FROM information_schema.columns a,\n information_schema.columns b,\n information_schema.columns c\n WHERE a.table_name = b.table_name\n and a.table_name = c.table_name\n and b.column_name = 'id'\n and c.column_name = 'active'\n and a.column_name = '{$column_name}'";
$cols = sql_array($sql);
if ($cols) {
echo '<hr />';
foreach ($cols as $col) {
$count = aql::count("{$col['table_name']} { where {$column_name} = '{$id}' }");
if ($count) {
?>
<p>
<a href="/dev/ide/<?php
echo $col['table_name'];
?>
/<?php
echo $column_name;
?>
/<?php
echo $id;
?>
"
class="ide"
>
