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 '
';
echo '';
echo 'Section | ';
echo 'Competition | ';
echo 'Position | ';
echo 'Trophy Name | ';
echo 'Holders | ';
echo 'Session Presented | ';
echo 'Joint? | ';
echo '
';
foreach($rows as $row)
//print your table rows
{
echo '';
echo '' . $row->section . ' | ';
echo '' . $row->competition . ' | ';
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 '' . $isjoint . ' | ';
echo '
';
if (empty($row->image)) {
echo '';
echo '';
echo ' |
';
}
echo '
';;
return get_defined_vars();
;}