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 holders LIKE "%14th West Bromwich%" ORDER BY FIELD(Section, "Anchors", "Juniors", "Company", "Seniors"), Competition ASC'); $rows = $db->loadObjectList(); if( $db->getNumRows() <1 ) { echo . $db->getNumRows } else { 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 . ' | '; if ($row->joint ==1) { $isjoint="Yes"; $boldopen=""; $boldclose=""; } else { $isjoint=""; $boldopen=""; $boldclose=""; } echo '' .$boldopen . '' . $isjoint . '' .$boldclose. ' | '; echo '