in a form, how to get db data into dropdown?

[eddiex666]

I have a form and i want the data from my table to be in a dropdown menu
my db contains: 'name' = 'Elvis'

I tryed to set my element to "field" and do a sql query.

like this:
$query1->setQuery(SELECT id,name FROM `table1`.users;
$db->setQuery($query1);
$result1 = $db->loadResult();

return $result1;

but it does not show anything in my form...

any ideas?

Greetings Eddie

 

[startpoint]

Use this element:
http://fabrikar.com/forums/index.php?wiki/database-join-element/