Unnamed

/* PAGE = VIEWTICKETS.PHP */

<html>
	<head>
		<title>View Support Tickets</title>
	</head>

	<body>
		<?
			include "init.php";
		?>
		<center>
			<div class = "content">
				<div id = "main">
					<table cellspacing = "0" cellpadding ="0" border = "0">
						<tr>
							<td width = "900" valign = "top">
								<a href = "index.php?link=new_ticket">Create a new Ticket</a>
								<a href = "index.php?link=answer_tickets">Answer a new Ticket</a>
								<br /><br />
								<a href = "index.php?link=view_tickets&sort=timestamp">Sort by time</a><br />
								<a href = "index.php?link=view_tickets&sort=ticket">Sort by ticket</a><br />
								<a href = "index.php?link=view_tickets&sort=email">Sort by email</a><br />
								<a href = "index.php?link=view_tickets&sort=subject">Sort by subject</a><br />
								<a href = "index.php?link=view_tickets&sort=status">Sort by status</a><br />
								<a href = "index.php?link=view_tickets&sort=problem">Sort by problem</a><br />
								<a href = "index.php?link=view_tickets&sort=solution">Sort by solution</a><br />

								<?
									$sort = $_GET['sort'];
									if (!$sort) {
										$sort = 'status';
									}

									mysql_connect("localhost", "efritz", "zarathustra");
									mysql_select_db("support_ticket");

									$query = "SELECT * FROM tickets ORDER BY $sort";
									$result = mysql_query($query);

									while($row = mysql_fetch_array($result)) {
										echo '<table cellspacing = "0" cellpadding = "0" border = "1">';
											echo '<tr>';
												echo '<td>'.$row['timestamp'].'</td>';
												echo '<td>'.$row['ticket'].'</td>';
												echo '<td>'.$row['email'].'</td>';
												echo '<td>'.$row['subject'].'</td>';
												echo '<td>'.$row['status'].'</td>';
											echo '</tr>';
											echo '<tr>';
												echo '<td colspan = "5">'.$row['problem'].'</td>';
											echo '</tr>';
											echo '<tr colspan = "5">';
												echo '<td colspan = "5">'.$row['solution'].'</td>';
											echo '</tr>';
										echo '</table>';
										echo '<br />';
									}
								?>
							</td>
						</tr>
					</table>
				</div>
			</div>
		</center>
	</body>
</html>