dynamically creating checkbox options from table, but...

[usdc-or]

If my query to the table where I'm getting my options from returns nothing (which it should sometimes), I get one checkbox with no label. Anyway to get rid of it?

I'm using the code suggested in the checkbox element:

$db = JFactory::getDbo();
$db->setQuery('SELECT id, text FROM #__tablename');
$rows = $db->loadObjectList();
foreach ($rows as $row) {
$options[] = JHTML::_('select.option', $row->id, $row->text);
}
return $options;

Works fine until the query returns nothing. Any assistance would be appreciated!

 

[cheesegrits]

I don't have time to look at this before flying to Houston. Can you bump this on Monday.

-- hugh

 

[troester]

If there are no options you must return an empty array, otherwise it's displaying the defined suboptions.
Something like
...
if (!is_array($options) ) $options[]='';
return $options;

 

[usdc-or]

That did it, thank you very much. I got very close to that but never quite got it.