I'd like to populate a dropdown with info from a database where which things are populated are based on an answer in another field. From help about doing this I've set this up but I don't know what goes in the spot "WHATGOESHERE". What I want to be there is {OwnerDeveloper:value} but I'm not sure how to refer to that in the code.

Thanks,
Susanne

//<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[] = "| [c]";

// Run the SQL query and store it in $results
$db->setQuery("SELECT name, name FROM #__ce_details WHERE con_position='WHATGOESHERE' ");
$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->name;
$label = $result->name;
$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>