| Index
» Projects
» phpMyEdit
» Forum
» Lookup value from second table |
 |
Davey
Joined: 31 Mar 2011
Posts: 16777215
Posted: 2011-03-31 18:11
Back to top
Reply with quote
|
I've just managed to get the following to pull a Drop-Down list of values from a second lookup table. Can't reply to the original post for some reason, so just mentioning it here in case it helps someone.
| Code: |
$opts['fdd']['sku'] = array(
'name' => 'SKU',
'select' => 'D',
'options|CDVL' => 'CDRVL', // adding |<opts> limits the options setting to only the specified operations (CDV)
'sort' => true,
'values|A' => array(
'table' => 'sku_groups',
'orderby' => 'grp ASC',
'column' => 'grp',
'description' => array('columns' => array('grp','next_id')), // these column fields get concatenated to provide the actual values listed
)
);
|
I have a second table named 'sku_groups', with a 'grp' column and a 'next_id' column. When I Add a new item, the above creates a Drop-Down list containing all 'grp'+'next_id' values to allow me to choose the appropriate group for the item (something like 'ZZ42').
Because of the |A option setting on 'values', it only shows the dropdown on Add page. On other pages it shows it as a read-only textbox.
What I really want to do though
is to format the result of the 'description' concatenation. How could I force it to always return a 3 digit number (eg. ZZ001, ZZ042, etc.)?
(I have a big bump on my head trying to work this out, so any help appreciated.)
|
stanneo
Joined: 03 Feb 2011
Posts: 14
Posted: 2011-03-31 22:20
Back to top
Reply with quote
|
thank you for posting,
every working example is valuable, :-)
greetings
stanneo
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
