sma-website /training/trainingcentreschedule.php

Language PHP Lines 153
MD5 Hash e80b046f729c1d28d4141209eb54e1c4 Estimated Cost $1,114 (why?)
Repository https://bitbucket.org/molusc/sma-website.git View Raw File
  1
  2
  3
  4
  5
  6
  7
  8
  9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
<?php session_start();  ?>
<?php require_once('../Connections/bryanmadge.php'); ?>
<?php

if (!isset($_GET["club"]))
    $_GET["club"] = "cf";
$clubprefix = $_GET["club"];

if (!isset($_GET["orderby"]))
    $_GET["orderby"] = "course_date";
$sortorder = $_GET["orderby"];

$colname_ClubInfo = "cf";
if (isset($HTTP_GET_VARS['club'])) {
  $colname_ClubInfo = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['club'] : addslashes($HTTP_GET_VARS['club']);
}
mysql_select_db($database_bryanmadge, $bryanmadge);
$query_ClubInfo = sprintf("SELECT trainingclubs.clubid, trainingclubs.clubname, trainingclubs.clubprefix, trainingclubs.standardfees, trainingclubs.clubfees, UNIX_TIMESTAMP(trainingclubs.feesfixeduntilend) AS feesfixeduntilend, trainingclubs.coursetime, trainingclubs.description FROM trainingclubs WHERE clubprefix = '%s'", $clubprefix);
$ClubInfo = mysql_query($query_ClubInfo, $bryanmadge) or die(mysql_error());
$row_ClubInfo = mysql_fetch_assoc($ClubInfo);
$totalRows_ClubInfo = mysql_num_rows($ClubInfo);

mysql_select_db($database_bryanmadge, $bryanmadge);
$query_TrainingClub = "SELECT schedule.course_id, schedule.course_title_id, catalog.title, UNIX_TIMESTAMP(schedule.course_date) AS course_date,  schedule.course_town, schedule.course_venue_id, schedule.course_classification
FROM schedule INNER JOIN catalog ON schedule.course_title_id = catalog.catalog_id
WHERE catalog.categoryid NOT IN(21) AND schedule.course_classification Like '$clubprefix%' ORDER BY $sortorder";
$TrainingClub = mysql_query($query_TrainingClub, $bryanmadge) or die(mysql_error());
$row_TrainingClub = mysql_fetch_assoc($TrainingClub);
$totalRows_TrainingClub = mysql_num_rows($TrainingClub);
?>
<html><!-- InstanceBegin template="/Templates/general.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<LINK REL="SHORTCUT ICON" HREF="../favicon.ico">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="Dreamweaver MX">
<meta name="keywords" content="CDM Regulations, CESMM, civil engineering, construction management, contract administration, contract procedures, courses, environmental awareness, geotechnical, Health and safety, ICE Conditions of Contract, ICE Professional Review, JCT Form of Contract, Method of Measurement for Highway Works, MMHW, NEC New Engineering and Construction Contract, Project management, report writing, site supervision, Standard Forms of Contract, training, AMPR, CET, CPD, TMPR, Eurocodes">
<!-- #BeginEditable "doctitle" -->
<title><?php echo $row_ClubInfo['clubname']; ?> Training Club Schedule - Symmons Madge Associates Ltd</title>
<!-- #EndEditable -->
<link rel="stylesheet" href="../bma.css" type="text/css">
<link rel="stylesheet" href="../print.css" type="text/css" media="print" />
<!-- InstanceParam name="OptionalPageTitle" type="boolean" value="true" --><!-- InstanceParam name="OptionalBreadcrumbs" type="boolean" value="true" --><!-- InstanceParam name="Google Analytics Code" type="boolean" value="true" -->
</head>

<body><div class="printhide"><!-- #BeginLibraryItem "/Library/Masthead.lbi" -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="150" rowspan="2"><a href="../home.html" target="_top">
      <!--        	<img src="../images/smalogo_sml_party_hat.gif" ALT="Symmons Madge Associates Ltd home" width="124" height="90" border="0">
-->
      <img src="../images/smalogo_sml.gif" ALT="Symmons Madge Associates Ltd home" width="124" height="64" border="0"> </a></td>
    <td><p class="tagline"><font size="4">Training for a Successful Future</font></p></td>
  </tr>
  <tr>
    <td valign="bottom"><table class="masthead" width="100%" height=25 border="0" cellpadding="0" cellspacing="0">
      <tr>
        <!--  	<td width="5%" bgcolor="#FFFFFF">&nbsp;</td>-->
        <td align="left" valign="top"><img src="/images/corner_TL.gif" width="15" height="25"></td>
        <td>&nbsp;&nbsp;<a 		  
						href="../courses/index.php" target="_top">Courses</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
						href="../diary/diary.php" target="_top">Course&nbsp;Diary</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
						href="training-club.php" target="_top">Regional Training</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
						href="../consultancy/index.html" target="_top">Consultancy</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
						href="../search/index.php" target="_top">Search</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
                        href="../links.html" target="_top">Links</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
						href="../company/about.html" target="_top">About us</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
						href="../contact.html" target="_top">Contact</a>&nbsp;&nbsp;</td>
      </tr>
    </table></td>
  </tr>
</table>
<!-- #EndLibraryItem --></div>
<div class="printonly">
  <div align="right"><img src="../images/smalogo_sml.gif" width="124" height="64" class="floatright"></div>
</div>
<div id="main"> 
  <p class="breadcrumbs printhide"><!-- #BeginEditable "breadcrumbs" --><a href="/home.html" target="_top">Home</a>&nbsp;&gt;&nbsp;<a href="index.html">Training</a>&nbsp;&gt;&nbsp;<a href="trainingcentre.php">Regional
    Training Centres</a>&nbsp;&gt;&nbsp;<?php echo $row_ClubInfo['clubname']; ?><!-- #EndEditable --></p>
  <h1 class="bmapagetitle"><!-- #BeginEditable "title" --> <?php echo $row_ClubInfo['clubname']; ?> Training Centre schedule <!-- #EndEditable --></h1>
  <!-- #BeginEditable "body" -->
	<div class="bmabody">
      <p>
        <?php // echo $query_TrainingClub ?>
      </p>
      <h2>We welcome both members and external delegates on all Training Centre courses</h2>
      <p><?php echo $row_ClubInfo['description']; ?></p>
    <table BORDER="0" CELLPADDING="2" CELLSPACING="3">
      <tr>
        <td COLSPAN=2><div align="right" class="bmabody"><font size="-1">Sort by: <a href="training-club-schedule.php?orderby=course_date&club=<? echo $clubprefix ?>">Date</a> or <a href="training-club-schedule.php?orderby=title&club=<? echo $clubprefix ?>">Course Title</a></font></div></td>
      </tr>
      <tr bgcolor="#000066"><td class="bmatableheaderlink"><div align="left"><font color="#FFFFFF" SIZE="-1"><strong><a href="training-club-schedule.php?orderby=course_date&club=<? echo $clubprefix ?>">Date</a></strong></font></div></td>
        <td class="bmatableheaderlink"><div align="left"><font color="#FFFFFF" SIZE="-1"><strong><a href="training-club-schedule.php?orderby=title&club=<? echo $clubprefix ?>">Course Title </a></strong></font></div></td>

      </tr>
      <?php do { ?>
      <tr bgcolor="#E5E5E5"><td><div align="right"><font size="-1">
            <?php $dt = $row_TrainingClub['course_date'];
		echo date('jS F Y', $dt);
		?>
        </font></div></td>
        <td><font size="-1"><?php echo "<a href=\"/courses/course-details.php?id=",$row_TrainingClub['course_title_id'],"\">",$row_TrainingClub['title'],"</a>"; ?></font></td>

      </tr>
      <?php } while ($row_TrainingClub = mysql_fetch_assoc($TrainingClub)); ?>
    </table>
    <p>The course time for this Training Centre is <strong><?php echo $row_ClubInfo['coursetime']; ?>.</strong></p>
    <h3>Fees (to end
    <?php $dt = $row_ClubInfo['feesfixeduntilend'];
		echo date('M Y', $dt); ?>)
</h3>
	<?php
	if(isset($_SESSION['company']))
		echo '<p style="color: #FF0000"><strong>Discounted rate for '.$_SESSION['company'].' Employees: &pound;'.$_SESSION['companyrate'].' per day + VAT.</strong></p><p>&nbsp;</p.';
	else {
 ?>
    <p>Standard Rate &pound;<?php echo $row_ClubInfo['standardfees']; ?> + VAT per day.<br>
    Club Members &pound;<?php echo $row_ClubInfo['clubfees']; ?> + VAT per day.</p>
    <ul>
      <li>If your organisation has already, or decides to commit to a minimum of 12 places over the training year, you would qualify for the members&rsquo; discounted rate - please ask for details</li>
      <li> Payment - we invoice after each course</li>
    </ul>
	<?php } ?>
    <p><strong>For further information</strong> please contact Sue Chatfield:<br>
    Tel 01446 775959 - Fax 01446 775758<br>
    Email <a href="mailto:sue.chatfield@symmonsmadge.co.uk">sue.chatfield@symmonsmadge.co.uk</a></p>
  </div>
<!-- #EndEditable --></div>
<div class="printhide"><!-- #BeginLibraryItem "/Library/Full Footer.lbi" --><hr width="65%">
<p align="center"><!-- #BeginLibraryItem "/Library/Footer.lbi" --><!-- #EndLibraryItem --></p>

<!-- #EndLibraryItem --><!-- #BeginLibraryItem "/Library/Legal footer.lbi" --><div align="center" class="bmabody"><font size="1"><a href="../company/legal.html">Legal
      Notice</a><br>
  Copyright &copy; Symmons Madge Associates Ltd, All Rights Reserved</font></div>
<!-- #EndLibraryItem --><!-- Start of StatCounter Code -->
<script type="text/javascript" language="javascript">
var sc_project=337750; 
var sc_partition=1; 
</script>

<script type="text/javascript" language="javascript" src="http://www.statcounter.com/counter/counter.js"></script><noscript>
<a href="http://www.statcounter.com/" target="_blank"><img  src="http://c2.statcounter.com/counter.php?sc_project=337750&amp;java=0" alt="counter stats" border="0"></a>
</noscript>
<!-- End of StatCounter Code -->
<!-- InstanceBeginEditable name="EditRegion1" --><!-- #BeginLibraryItem "/Library/Google Analytics PHP Include.lbi" -->
	<?php include_once($_SERVER['DOCUMENT_ROOT'] . "/analyticstracking.php"); ?><!-- #EndLibraryItem --><!-- InstanceEndEditable --></div>
</body>
<!-- InstanceEnd --></html>
<?php
mysql_free_result($ClubInfo);

mysql_free_result($TrainingClub);
?>
Back to Top