I’d like to use the CONCAT function to join two fields in order to display the concatenated info as the ‘label info’ for a list box in my lightbox form.
Here is my php code:
$list = new OptionsConnector($res);
$list->render_sql("select 'ID', CONCAT('ID', 'DATE') AS Info FROM promos AS promos ORDER BY Date Desc","ID","ID(value),Info(label)");
$scheduler->set_options("promos", $list);
On my lightbox in the scheduler, nothing displays. Just blank information.
And this doesn’t work:
$list = new OptionsConnector($res);
$list->render_table("promos","ID","ID(value),CONCAT(ID, Date)(label)");
$scheduler->set_options("promos", $list);