Location: PHPKode > projects > K-12 OSS Web Software Project > equest_0.1/teacher/members.php
<?php
include("../config.php");

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

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

<!-- start teacher list block -->
  <tr>
    <td class="text" bgcolor="#ffffff" valign="top">
<blockquote>
<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>

<?php 
$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>";
}
$numrows=mysql_num_rows($result);
if ($numrows == 0)
{}
?>


</blockquote>
    </td>
  </tr>
<!-- end teacher list block -->


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