I followed this link to populate a drop down however i get error
http://fabrikar.com/forums/index.php?wiki/dropdown-element/
I have==============
$options[] = JHTML::_('select.option','1','select');
$options = array();
$query = 'SELECT id, order_id FROM xoms_mgls';
$db->setQuery($query);
$rows = $db -> loadObjectList();
foreach ($rows as $row) {
$options[] = JHTML::_('select.option',$row->id, $row->order_id);
}
return $options;
======================
Error
======================
Fatal error: Call to a member function setQuery() on a non-object in /home/site/public_html/components/com_fabrik/models/element.php(3563) : eval()'d code on line 4
$db->setQuery($query);
thanks
http://fabrikar.com/forums/index.php?wiki/dropdown-element/
I have==============
$options[] = JHTML::_('select.option','1','select');
$options = array();
$query = 'SELECT id, order_id FROM xoms_mgls';
$db->setQuery($query);
$rows = $db -> loadObjectList();
foreach ($rows as $row) {
$options[] = JHTML::_('select.option',$row->id, $row->order_id);
}
return $options;
======================
Error
======================
Fatal error: Call to a member function setQuery() on a non-object in /home/site/public_html/components/com_fabrik/models/element.php(3563) : eval()'d code on line 4
$db->setQuery($query);
thanks