$db = JFactory::getDBO(); $query = $db->getQuery(true); $sessions = $_POST['form']['Sessions']; array_unshift($sessions, 'ALL'); if($sessions[0]=='ALL') { $sql = "SELECT `COLUMN_NAME` FROM `INFORMATION_SCHEMA`.`COLUMNS` WHERE `TABLE_SCHEMA` = 'mintoska_5942395' AND `TABLE_NAME` = 'skat_rsform_skater_sessions'"; $db->setQuery($sql); $db->query(); $sessions= $db->loadAssocList(); for($i=1;$ip {margin: 0}' . '

'.$sessions[$i] . '

'; $sql = "SELECT `{$sessions[$i]}` FROM `#__rsform_skater_sessions` WHERE `{$sessions[$i]}` !='NULL' AND `{$sessions[$i]}` !='' ORDER BY `{$sessions[$i]}`"; $db->setQuery($sql); $db->query(); $skaters= $db->loadAssocList(); for($j=0;$j' . $skaters[$j][$sessions[$i]] . '

'; } } echo $thankYouMessage; } else { for($i=0;$ip {margin: 0}' . '

'.$sessions[$i] . '

'; $sql = "SELECT `{$sessions[$i]}` FROM `#__rsform_skater_sessions` WHERE `{$sessions[$i]}` !='NULL' AND `{$sessions[$i]}` !='' ORDER BY `{$sessions[$i]}`"; $db->setQuery($sql); $db->query(); $skaters= $db->loadAssocList(); for($j=0;$j' . $skaters[$j][$sessions[$i]] . '

'; } } echo $thankYouMessage; }