<?php
if (permissionOnlyTeacher()) {
$sql = "SELECT * FROM course ORDER BY year";
} else {
$sql = "SELECT * FROM course WHERE year='{$year}'";
}
$courseResult = mysql_query($sql);
while ($courseRow = mysql_fetch_array($courseResult)) {
$id = $courseRow['course_id'];
$sql = "SELECT * FROM slides WHERE course_id='{$id}'";
$slideResult = mysql_query($sql);
$got = 0;
while ($slideRow = mysql_fetch_array($slideResult)) {
if (!$got) {
$got++;
echo "<h3>" . getCourseNo($slideRow['course_id']) . "</h3>";
}
?>
<a href="<?php
$slideRow['directory'];
?>
"><u><?php
echo $slideRow['title'];
?>
</u></a>
<?php
if (permissionOnlyTeacher()) {
?>
<a href="processing/delete.php?id=<?php
echo $slideRow['id'];
<?php
$con = mysql_connect("localhost", "root", "");
mysql_select_db('test', $con);
/*echo "$con";*/
function getCourseNo($id)
{
/*$sql="SELECT * FROM course ORDER BY id DESC LIMIT 0,3";
$result=mysql_query($sql);
while ($row=mysql_fetch_array($result)) {
return $row['course_title'];
}*/
$sql_course = "SELECT * FROM course WHERE course_id='{$id}'";
$result = mysql_query($sql_course);
$course_id = 0;
while ($row = mysql_fetch_array($result)) {
return $row['course_title'];
}
}
echo getCourseNo(2);
<h2>All CT Results:</h2></br>
<ul>
<?php
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$ct_id = $row['ct_id'];
$course_id = $row['course_id'];
$ct_no = $row['ct_no'];
$day = $row['published'];
?>
<li>
<a href=" <?php
echo $publish . $ct_id;
?>
"><u><?php
echo getCourseNo($row['course_id']) . " CT no " . $ct_no;
?>
</u></a> published on <?php
echo $day;
?>
</li>
<?php
}
?>
</ul>
</div>
</div>
<?php
include "processing/footer.php";
?>
