Location: PHPKode > projects > Gsys > php/tshirts.php
<?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>
Return current item: Gsys