0;*/ $_t4StyleInternal = $internal; if($_t4StyleInPreview){ $_t4StyleBaseServer = 'https://t4.gla.ac.uk'; } else { $_t4StyleBaseServer = 'http://www.gla.ac.uk'; } if($_SERVER['SERVER_NAME'] == 'udcf.gla.ac.uk') { $_t4StyleBaseServer = 'https://udcf.gla.ac.uk'; } elseif($_SERVER['SERVER_NAME'] == 'www2.gla.ac.uk') { $_t4StyleBaseServer = 'https://www2.gla.ac.uk'; } elseif(($_SERVER['SERVER_NAME'] == 'www.gla.ac.uk')&&($_SERVER['REQUEST_SCHEME'] == 'https')) { $_t4StyleBaseServer = 'https://www.gla.ac.uk'; } ?> edit in t4', $internal); ?>

Fees 2017/18

'.$college['college_name'].''; echo ''."\r\n"; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''."\r\n"; echo ''; echo ''; $feesq = "SELECT * FROM structure_courses, structure_courses_fees_coursesbands_1718, structure_degreedesignations WHERE structure_courses.course_id = structure_courses_fees_coursesbands_1718.course_id AND structure_degreedesignations.degree_designation_id = structure_courses_fees_coursesbands_1718.degree_designation_id AND structure_courses.deleted = '0' AND structure_courses.pending = '0' ORDER BY structure_courses.course_name ASC"; $feesr = mysql_query($feesq); $fees_num_rows = mysql_num_rows($feesr); while($fees = mysql_fetch_array($feesr)) { //get first establishment link $currentCourse = $fees['course_id']; $estq = "SELECT * FROM structure_coursesestablishments WHERE course_id = '$currentCourse' LIMIT 1"; $estr = mysql_query($estq); $est_details = mysql_fetch_row($estr); //echo $est_details[0]; //get college $college = getCollege($est_details[0], $conn); //echo $college['college_name']; //echo '

'.$college['college_estno'].' - '; //echo $collegeId.'

'; echo ''; if($college['college_estno'] == $collegeId){ echo ''; echo ''; //find out band and value $band_id_home = $fees['band_id_home']; $band_id_int = $fees['band_id_international']; $q = "SELECT * FROM structure_courses_fees_bands_1718 WHERE band_id = '$band_id_home'"; $r = mysql_query($q); if(mysql_num_rows($r) > 0) { while($band = mysql_fetch_array($r)){ $adjustedCost = $band['cost'] + $fees['cost_adjustment_home']; echo ''; } } else { echo ''; } $q = "SELECT * FROM structure_courses_fees_bands_1718 WHERE band_id = '$band_id_int'"; $r = mysql_query($q); if(mysql_num_rows($r) > 0) { while($band = mysql_fetch_array($r)){ $adjustedCost = $band['cost'] + $fees['cost_adjustment_int']; echo ''; } } else {echo '';} echo ''; echo ''."\r\n"; } } echo ''; echo '
ProgrammeDesignationHome feeInternational feeNotes
'; echo $fees['course_name']." "; echo ''; echo $fees['degree_designation']; echo ''; //echo '£'.$band['cost']; echo '£'.$adjustedCost; echo ' '; //echo '£'.$band['cost']; echo '£'.$adjustedCost; echo ' '.$fees['notes'].'
'."\r\n"; } ?>