Location: PHPKode > projects > K-12 OSS Web Software Project > equest_0.1/teacher/members.php

if (!(isset($_SESSION['teacher']))) {
       header("Location: ../index.php");

<title>eQuest Web Quest System</title>
<link type="text/css" rel="stylesheet" href="./styles.css">
<table class="maintable" bordercolor="#000066" cellspacing="0" cellpadding="3" align="center" border="1" width="600">
<?php include("./header.php"); ?>

<!-- start teacher list block -->
    <td class="text" bgcolor="#ffffff" valign="top">
<p><a href="create.php">Create a new webquest</a></p>
<p>Below is a list of all the web quests you have created.</p>

$query = "SELECT quest_unique,quest_title,UNIX_TIMESTAMP(quest_date) AS poster_time FROM quests WHERE quest_teacher='{$_SESSION["teacherid"]}' ORDER BY quest_date DESC"; 
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
$timestamp = date("d-M-Y g:i A", $row["poster_time"]);
	print "<p><b>{$row["quest_title"]}</b><br>";
	print "<a href=\"edit.php?quest={$row["quest_unique"]}\">Edit WebQuest</a> | ";
	print "<a href=\"view.php?quest={$row["quest_unique"]}\">View WebQuest</a> | ";
	print "<a href=\"delete.php?quest={$row["quest_unique"]}\">Delete WebQuest</a><br>";
	print "Created: $timestamp</p>";
if ($numrows == 0)

<!-- end teacher list block -->

<?php include("./footer.php"); ?>
Return current item: K-12 OSS Web Software Project