| Index
» Projects
» phpMyEdit
» Forum
» Table lookup via key: How ? |
 |
Silberdrache
Joined: 08 Sep 2006
Posts: 7
Posted: 2006-09-08 12:51
Back to top
Reply with quote
|
I have two tables:
Table: maturand
key: maturand_id
Field: maturand_name
Table: beratung
foreign key: id_beratung_maturand
Where "maturand_id" equals "id_beratung_maturand".
So first I am showing table "maturand" where you can click an a name (=field "maturand_name")
The URL looks like this:
http://www.admin.acap.ethz.ch/phpmyedit/beratung.php?PME_sys_operation=Change&PME_sys_rec=383
The "383" is the correct key. After clicking on the link I'd like to see now only those records
in table "beratung" where "id_beratung_maturand" is "383".
Unfortunately at the moment just all records in "beratung" will be shown.
Here is my code:
$opts['fdd']['maturand_name'] = array(
'name' => 'Maturand name',
'select' => 'T',
'maxlen' => 255,
'textarea' => array(
'rows' => 5,
'cols' => 50),
'sort' => true,
'URL' => 'beratung.php?PME_sys_operation=Change&PME_sys_rec=$key',
'values' => array(
'table' => 'beratung',
'column' => 'id_beratung_maturand')
);
Next step would be to create a new record with the
$key in table "beratung". Can that somehow be integrated, too ?
I am really hoping to finding a solution.
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2006-09-08 14:32
Back to top
Reply with quote
|
probably
?fl=1&PME_sys_qf3=$key
should work (the same as when you use filters)
|
Silberdrache
Joined: 08 Sep 2006
Posts: 7
Posted: 2006-09-08 14:36
Back to top
Reply with quote
|
GREAT !
It's working and exactly what I was searching for !
Thanks a lot :-)
Additional question:
Is there some documentation für URL parameters
like PME_sys_operation, PME_sys_rec etc. ?
Could not find it anywhere.
|
michal
Joined: 17 Jun 2003
Posts: 537
Location: Slovakia
Posted: 2006-09-08 14:44
Back to top
Reply with quote
|
not sure,
prefixes are mentioned (in cvs or in upcoming release)
usually just opening the html file helps a lot
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
