Index
» Projects
» phpMyEdit
» Forum
» Join Problem |
|
minal
Joined: 26 Aug 2009
Posts: 2
Posted: 2009-08-26 09:18
Back to top
Reply with quote
|
I 've two tables 'mpt last version' and 'mpt father'.
'mpt father' has foriegn key as 'Code' by which it is linked with 'mpt last version'.
Here is my code that i am using to get 'father' field from 'mpt father' :
$opts['fdd']['father'] = array(
'name' => 'Father',
'maxlen' => 20,
'sort' => true ,
'sql'=>'PMEjoin6.father',
);
$opts['fdd']['father']['values']['table'] = 'mpt father';
$opts['fdd']['father']['values']['column'] = 'code';
$opts['fdd']['father']['values']['description'] = 'father';
$opts['fdd']['father']['values']['join']= 'PMEtable0.code=PMEjoin6.code';
Problem is when i click on view/change then it not able to show because it passing blank value to code in the url.
Can any one please suggest me whats wong in it?
Thanks
|
Post new topic
Reply to topic
|
|
|
|