Pulldown with database entries not working on CF8

Dear all,

in CF7, this form works fine. But after importing and testing on CF8, there are no more options fetched from the database. Does anyone see where I have to adapt the script? I am not a programmer, so please bear with me.

$current_day = JFactory::getDate('+0 seconds');

$current_day = $current_day->toUnix();

$options = array();

$db =& JFactory::getDBO();$query = "

SELECT

#__jevents_vevdetail.dtstart,

#__jevents_vevdetail.summaryFROM

#__jevents_vevdetailINNER JOIN #__jevents_vevent ON #__jevents_vevdetail.evdet_id = #__jevents_vevent.detail_id

WHERE    #__jevents_vevdetail.dtstart > " . $current_day ." AND   

#__jevents_vevent.access = 1 AND   

#__jevents_vevent.state >= 1

order by #__jevents_vevdetail.dtstart;

";

$db->setQuery($query);

return $db->loadAssocList();

foreach ( $data as $d ) { 

$options[] = "<option value='{$d->summary}'>{$d->summary}</option>";

}

Thanks for your precious help!

Martin

Great, thanks for posting the solution.

That's it, you have to use {row:summary} in the Dynamic Options settings