| Index
» Projects
» phpMyEdit
» Forum
» url direct linking tto edit screen of other table |
 |
bentuinstra
Joined: 12 Sep 2004
Posts: 29
Posted: 2004-11-27 16:11
Back to top
Reply with quote
|
Hi all,
Thanks for the nice tool, I'm starting to work with it and until now it does everything I want.
But now my question.
Lets say I've two tables. One with personal information and one with adres information (since more people can live at one adres).
Every person has an adres_id in the personal table which links to the adres_id in the adres table. Now I would like to link from the personal table directly to the editmode of the selected adres_id. So I can change the adres of that person directly. The code below is how far I've come.
The code below works sofar that I jump to the adres table. But not with the selected adres_id, and not into an edit mode.
Any help is very appriciated.
Ben
| Code: |
$opts['fdd']['ADRES_ID']['values']['table'] = 'ADRES';
$opts['fdd']['ADRES_ID']['values']['column'] = 'ADRES_ID';
$opts['fdd']['ADRES_ID']['name'] = 'ADRES';
$opts['fdd']['ADRES_ID']['maxlen'] = 25;
$opts['fdd']['ADRES_ID']['nowrap'] = true;
$opts['fdd']['ADRES_ID']['select'] = 'D';
$opts['fdd']['ADRES_ID']['sort'] = 'true';
$opts['fdd']['ADRES_ID']['values']['description']['columns'][0] = 'STRAAT';
$opts['fdd']['ADRES_ID']['values']['description']['divs'][0] = ' ';
$opts['fdd']['ADRES_ID']['values']['description']['columns'][1] = 'HUISNUMMER';
$opts['fdd']['ADRES_ID']['values']['description']['divs'][1] = ' ';
$opts['fdd']['ADRES_ID']['values']['description']['columns'][2] = 'TOEVOEGING';
$opts['fdd']['ADRES_ID']['values']['description']['divs'][2] = ' (TEL: ';
$opts['fdd']['ADRES_ID']['values']['description']['columns'][3] = 'TELEFOON';
$opts['fdd']['ADRES_ID']['values']['description']['divs'][3] = ')';
$opts['fdd']['ADRES_ID']['URL'] = 'http://localhost/dedolfijn/adres.php?adres_id=$link'; |
|
hbernard
Joined: 23 Mar 2003
Posts: 159
Location: FRANCE
Posted: 2004-11-27 21:31
Back to top
Reply with quote
|
Well, I remember this question has been previously answered in another thread.
Basic idea was to use 'sql' field option and concat() sql function to build "by hand" the correct link, using the id value.
_________________
hbernard - phpMyEdit updater.
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
