Answers

• allan Posts: 64,941Questions: 1Answers: 10,756 Site admin

  January 2016 Answer ✓

  Hi,

  Unfortunately only the label can be given as an array (and will be combined in order to get the string output). There is no built in option to give an array for the value (I presume you want it concatenated into a single string value?).

  You would need to use a custom method if you want to use multiple database columns as the value for your select field.

  Allan
• Jhon Morano Posts: 2Questions: 1Answers: 0

  January 2016

  thx Allan for the fast response
  now it works :D

  Code for others:

  ->options( function () use ( $db ) {
              $attrList = $db->selectDistinct (
                      'tarife',
                      ['tconcesiune', 'zconcesiune', 'pconcesiune']);
                     $out[] = array('value' => '', 'label' => 'Alege valabilitatea');
              while ( $row = $attrList->fetch() ) {
           
                  $out[] = array(
                          "value" => $row['tconcesiune'].' Ani - Zona '.$row['zconcesiune'].' - '. $row['pconcesiune'] .' lei',
                          "label" => $row['tconcesiune'].' Ani - Zona '.$row['zconcesiune'].' - '. $row['pconcesiune'] .' lei'
                  ); }      
              return $out;
              })
  
• borconi Posts: 56Questions: 19Answers: 1

  September 2016

  Thanks @allan and @Jhon Morano this put me on the right track to solve my problem.
  P.S. It made me smile when I realized what language is the code in