Dropdown values
Posted: Tue May 07, 2019 2:47 am
Hi, How to generate dropdown values(array variable ) from using pm tables. (Working sample would be nice)
Thank you
Thank you
Code: Select all
@=varDataSource = array();
$result = executeQuery("SELECT MY_VALUE_FIELD, MY_LABEL_FIELD FROM PMT_MY_TABLE");
if (is_array($result)) {
foreach ($result as $row) {
@=varDataSource[] = array($row['MY_VALUE_FIELD'], $row['MY_LABEL_FIELD']);
}
}