Display column value in a dropbox

[acrocephalus]

Hello,
I am trying to get all the values (numeric) of the column Bruel_ID from database mpctz_rsform_bruels to display them in a RSForm dropdown box. I'm using this code:

//<code>
$db = JFactory::getDbo();
$db->setQuery("SELECT Bruel_ID FROM mpctz_rsform_bruels");
return $db->loadResult();
//</code>

Howeve, I am only pulling the lowest value of the column. How can I get all the values?
Thanks,

Dani

[diafol]

loadResult only returns one value. Did you read the documentation?

http://docs.joomla.org/J1.5:Accessing_the_database_using_JDatabase

You can use:

return $db->loadResultArray();