[PHPMyEdit-Discuss] multiple lookup colums(values)

[Ross J. <rj...@fi...>]

Compliments on a great scipt... I am using extensively..

Need help to write correct syntax

This definition works fine...

$opts['fdd']['act_con_idx'] =3D array(
 'name'=3D>'Contact',
 'select'=3D>'D',
 'type'=3D>'string',
 'maxlen'=3D>5,
 'nowrap'=3D>false,
 'sort'=3D>true,
 'values'=3D>array(
 'db'=3D>'xxxx_mgmt',
 'table'=3D>'contact',
 'orderby'=3D>'profile',
 'column'=3D>'con_idx',
 'description'=3D>'profile')
);

however when trying to have multiple colums and using below .... does =
not work
reporting invalid sql query

$opts['fdd']['act_con_idx'] =3D array(
 'name'=3D>'Contact',
 'select'=3D>'D',
 'type'=3D>'string',
 'maxlen'=3D>5,
 'nowrap'=3D>false,
 'sort'=3D>true
);
$opts['fdd']['act_con_idx']['values']['db']=3D'xxxx_mgmt';
$opts['fdd']['act_con_idx']['values']['table']=3D'contact';
$opts['fdd']['act_con_idx']['values']['orderby']=3D'profile';
$opts['fdd']['act_con_idx']['values']['column']=3D'con_idx';
$opts['fdd']['act_con_idx']['values']['table']=3D'contact';       =
$opts['fdd']['act_con_idx']['values']['description']['columns']['1']=3D'p=
rofile';
$opts['fdd']['act_con_idx']['values']['description']['divs']['1']   =
=3D'-';
$opts['fdd']['act_con_idx']['values']['description']['columns']['2']=3D'p=
hone_1';

 please help