Question about Select and Title.

Justere

Hello,
I have following code to load data from table to select list:

if ( ! isset($_POST['action']) ) {
    $out['lecturers'] = $db
        ->selectDistinct( 'lecturers', 'id_lecturer as value, surname as label' )
        ->fetchAll();
}

Question is:

It's possible to have few columns names at one label?
For example:

id_lecturer as value, surname & name & middlename as label.

For usability only.

allan

Hi,

Yes indeed. The label string can be anything you want and concatenating the values from columns is certainly an option. To do that use the sql() method with the concat or concat_ws SQL functions. For example you might have:

$out['lecturers'] = $db
    ->sql( 'SELECT DISTINCT id_lecturer as value, CONCAT_WS(' ', surname, name, middlename) as label ORDER BY label ASC' )
    ->fetchAll();

Allan

Justere

Thank you very much , Allan.

I'd like to add a little for users, who might read this thread.

It is necessary to add "FROM" parameter, because without it there will be no query.

    $out['lecturers'] = $db
            ->sql( 'SELECT id_lecturer as value, CONCAT(surname," ",name,middle_name) as label FROM lecturers ORDER BY label ASC')
            ->fetchAll();

allan

Oops! Thanks for pointing that out!

Allan