Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Thursday, March 28, 2024
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  Join Problem

phpMyEdit Features     Join Problem
Post new topic   Reply to topic    
 
minal     Joined: 26 Aug 2009   Posts: 2  
Post 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    

Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS
Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy