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 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 . ' | '; if ($row->Holders =="14th West Bromwich") { $color="red"; } else { $color="black"; } echo '' . $row->Holders . ' | '; echo '' . $row->SessionPresented . ' | '; echo '' . $row->Joint . ' | '; echo '