michael.a.clarkson
New Member
Hi am newbie to Fabrik and need some help my drop down is coming up blank
I have two tables. the main table is tbl_object and the reference table for the object type in this table is rft_object_types. rft_object_types is a simple list with no PK. (It's one text column called "ObjectType" it has no id and I do not want one.)
$options[] = JHTML::_('select.option', '0','Please select' );
$db = JFactory::getDbo();
$db->setQuery("SELECT * FROM visiodb_prod.rft_object_types");
$rows = $db -> loadObjectList();
foreach ($rows as $row) {
$options[] = JHTML::_('select.option', $row->text);
}
return $options;
I have two tables. the main table is tbl_object and the reference table for the object type in this table is rft_object_types. rft_object_types is a simple list with no PK. (It's one text column called "ObjectType" it has no id and I do not want one.)
$options[] = JHTML::_('select.option', '0','Please select' );
$db = JFactory::getDbo();
$db->setQuery("SELECT * FROM visiodb_prod.rft_object_types");
$rows = $db -> loadObjectList();
foreach ($rows as $row) {
$options[] = JHTML::_('select.option', $row->text);
}
return $options;