skyrun
Active Member
you can see it on the campaigns tab on my test website that you have in the column for location.
whatever the first row is on the table, it doesn't show up (see screenshot).
if the first happens to be a multiselect field, then the first element from the list is blank and the rest are there.
ALSO, i am building both value and text fields in the array that i'm sending from the eval populate, however only the value is showing up (KYST vs. Keystone Resort for example). works fine if i hard code...
fyi i have included code in the eval populate to make it easier to edit, the included code is:
then in eval populate, i have this:
whatever the first row is on the table, it doesn't show up (see screenshot).
if the first happens to be a multiselect field, then the first element from the list is blank and the rest are there.
ALSO, i am building both value and text fields in the array that i'm sending from the eval populate, however only the value is showing up (KYST vs. Keystone Resort for example). works fine if i hard code...
fyi i have included code in the eval populate to make it easier to edit, the included code is:
Code:
$db =& JFactory::getDBO();
$query = "SELECT loc_abbrev, location_name FROM mydb.mytable";
$db->setQuery($query);
if (!$db) die('Error in query: ' .mysql_error());
$locations = $db->loadObjectList();
if (!$locations) die('Can not find location list: ' .mysql_error());
$return = array(JHTML::_('select.option','ALL','All Locations'));
foreach ($locations as $location) {
$return[] = JHTML::_('select.option', $location->loc_abbrev, $location->location_name);
};
then in eval populate, i have this:
Code:
require_once('thenameofmyphpfile.php');
return $return