');
}#end if
else{
print("");
}
/* ***************************YEAR********************* */
/*Create the query to get old Fyer data based on selected org id*/
$oldNameQ = "SELECT fg.`ID` old_id, fg.`FyerSaveName` oldName, org.`Status` stat, fg.`FyerYear` fyear
FROM fyer_group fg
INNER JOIN organization org ON org.id = fg.`FyerOrg_id`
INNER JOIN (SELECT MAX(`FyerYear`) max_yr, `ID`, `FyerOrg_id` org_id
FROM fyer_group WHERE `FyerOrg_id` = '". $oid . "') yrMax
ON yrMax.org_id = fg.`FyerOrg_id` AND yrMax.max_yr = fg.`FyerYear`
WHERE fg.`FyerOrg_id` = '" . $oid . "' AND fg.`FyerFinal` = 'Final'";
/*Run query*/
$t = mysqli_query($dbc, $oldNameQ);
print('
');
}//end if
?>