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);

Cheers,

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 jos