<?PHP
//Filename : tshirts.php
//Description : show all tshirts available.
//Author : Marty
//Last modified : 2006.12.20
include("../includes/db.php");
include("../includes/auth.php");
$sql = "SELECT design_id, title FROM tshirts ORDER BY design_id ASC";
$result = mysql_query($sql,$connection) or die(mysql_error());
?>
<html>
<head>
<title>T-Shirts</title>
<link href="../includes/index.css" rel="stylesheet" type="text/css">
</head>
<body class="body">
<br />
<table width="810" height="626" border="0" align="center" cellpadding="15">
<tr>
<td height="128" colspan="2"><img src="../images/eg_banner.gif" width="810" height="172"></td>
</tr>
<tr>
<td width="27%" height="488" valign="top"> <?php include '../includes/nav.inc'; ?></td>
<td width="53%" valign="top">
<table>
<tr>
<th><strong>Shirt List</strong></th>
</tr>
<?php
//Setup counter
$counter = 1;
//Loop to print out all results
while ($row =mysql_fetch_array($result))
{
$design_id = $row['design_id'];
$title = $row['title'];
?>
<tr>
<td><?php echo("<a href=\"view_tshirt.php?cat=".$design_id."\" target=\"_blank\">".$title."</a>");?></td>
</tr>
<?php
} //Close loop
?>
</table>
</td>
</tr>
</table>
</body>
</html>