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_trophyholders WHERE competition="Swimming" OR competition="Fun Swim" AND state=1 ORDER BY FIELD(Section, "Anchors", "Juniors", "Company", "Seniors"), Competition ASC, FIELD(Position, "Winners", "Runners-up")'); $rows = $db->loadObjectList(); echo '
Section | '; echo 'Position | '; echo 'Trophy Name | '; echo 'Holders | '; echo 'Session Presented | '; echo 'Joint? | '; echo '|
' . $row->section . ' | '; echo '' . $row->position . ' | '; echo '' . $row->trophyname . ' | '; echo '' . $row->holders . ' | '; echo '' . $row->sessionpresented . ' | '; if ($row->joint ==1) { $isjoint="Yes"; $color="ccccff"; } else { $isjoint=""; $color="ffffff"; } echo '' . $row->isjoint . ' | '; echo '|
image . '"' );">image | '; echo '