input->getInt('Itemid'); if (is_array($src_variables)) {foreach ($src_variables as $src_key => $src_value) {${$src_key} = $src_value;}} $db = JFactory::getDBO(); $db->setQuery('select * from z8hcl_trophies ORDER BY FIELD(Section, 'Anchors', 'Juniors', 'Company', 'Seniors'), Competition ASC'); $rows = $db->loadObjectList(); echo '
Section | '; echo 'Competition | '; echo 'Position | '; echo 'Trophy Name | '; echo 'Holders | '; echo 'Session Presented | '; echo 'Joint? | '; echo '
' . $row->Section . ' | '; echo '' . $row->Competition . ' | '; echo '' . $row->Position . ' | '; echo '' . $row->TrophyName . ' | '; echo '' . $row->Holders . ' | '; echo '' . $row->SessionPresented . ' | '; echo '' . $row->Joint . ' | '; echo '