Im wondering if a person can provide me a little of the hands.
Im attempting to write a question in the PHP file in Joomla and it is not necessarily working that well, there is nothing being output.
Im very a new comer to this Joomla stuff, therefore if someone could tell me where im failing that might be great.
My code is the following:
$db =& JFactory::getDBO(); $query = "SELECT fullname FROM jos_jxzine_authors WHERE published = '1'"; $db->setQuery($query); $column = $db->loadResultArray(); echo JHTML::_('select.options', $column, 'value', 'text', $this->categoryMap);
Please make use of this query
$query = "SELECT fullname FROM `#__jxzine_authors` WHERE published = '1'";
joomla will itself add db prefix. Which means you must use
#_ rather than