| Index
» Projects
» phpMyEdit
» Forum
» Linking UID to logtable |
 |
RuiLapa
Joined: 04 Sep 2006
Posts: 1
Posted: 2006-09-04 17:37
Back to top
Reply with quote
|
Users:
Id bigint(10)
Name varchar(30)
Password varchar(30)
I would like to know who and what changed in the table.
For that I've configured 'logtable'.
I'm trying to link the Users record to the logtable without success.
$opts['fdd']['Id'] = array(
'name' => 'History',
'select' => 'D',
'display' => 'V',
'options' => 'VL',
'values' => array(
'table' => $opts['logtable'],
'column' => 'rowkey',
'filters' => sprintf ("tab='%s' AND operation='update'", $opts['tb'] ),
'description' => array(
'columns' => array('rowkey', 'col', 'oldval', 'newval'),
'divs' => array(' ', ':', '->')
)
),
);
Any help would be appreciated.
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2006-09-06 15:54
Back to top
Reply with quote
|
afaik, you are trying to make a n to m connection, which is really hard.
it would be easy to create an interface to logtable, make links to users and records. then use $opts['filters'] to limit the query.
then just create a link history to the logtable with appropriate filters.
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
