Обработка данных из базы - RS Form!

//<code>
// Prepare the empty array
$items = array();
// Prepare the database connection
$db = JFactory::getDbo();
// Keep this if you'd like a "Please select" option, otherwise comment or remove it
$items[] = "|Please Select[c]";
 
// Run the SQL query and store it in $results
$db->setQuery("SELECT your_value, your_label FROM #__your_table");
$results = $db->loadObjectList();
 
// Now, we need to convert the results into a readable RSForm! Pro format.
// The Items field will accept values in this format:
// value-to-be-stored|value-to-be-shown
// Eg. m|M-sized T-shirt
foreach ($results as $result) {
  $value = $result->your_value;
  $label = $result->your_label;
  $items[] = $value.'|'.$label;
}
 
// Multiple values are separated by new lines, so we need to do this now
$items = implode("\n", $items);
 
// Now we need to return the value to the field
return $items;
//</code>

$db->setQuery("SELECT your_value, your_label FROM #__your_table");
$results = $db->loadObjectList();

foreach ($results as $result) {
  $value = $result->your_value;
  $label = $result->your_label;
  $items[] = $value.'|'.$label;
}

$db->setQuery("SELECT your_value, your_label FROM #__your_table");
$results_1 = $db->loadObjectList();
$db->setQuery("SELECT your_value, your_label FROM #__your_table2");
$results_2 = $db->loadObjectList();

foreach ($results_1 as $result) {
  $value = $result_1->your_value;
  $label = $result_1->your_label;
  $items[1][] = $value.'|'.$label;
}
foreach ($results_2 as $result) {
  $value = $result_2->your_value;
  $label = $result_2->your_label;
  $items[2][] = $value.'|'.$label;
}

foreach ($results as $result) {
  $value = $result->your_value;
  $label = $result->your_label;
  $items[] = $value.'|'.$label;
}