<?php include("../include/secure.php"); ?>
<?php require_once('../include/connections.php'); ?>
<?php
mysql_select_db($database, $conn);
$query_client_list = "SELECT VendorID, VendorName FROM tt_vendors ORDER BY VendorName";
$client_list = mysql_query($query_client_list, $conn) or die(mysql_error());
$row_client_list = mysql_fetch_assoc($client_list);
$totalRows_client_list = mysql_num_rows($client_list);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Open Tickets</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../include/style.css" type="text/css" rel="stylesheet" />
</head>
<body topmargin="0">
<?php include("header.php"); ?>
<?php include("r_header.php"); ?>
<h1 align="center"><font face="Verdana, Arial, Helvetica, sans-serif">Tickets by Vendor</font></h1>
<table border="0" cellpadding="2" cellspacing="2" width="90%" align="center">
<tr>
<td bgcolor="#666666"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Vendors</strong></font></td>
</tr>
<?php do { ?>
<tr>
<td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="tt_view_clients.php?cl_id=<?php echo $row_client_list['VendorID']; ?>"><?php echo $row_client_list['VendorName']; ?></a></font></td>
</tr>
<?php } while ($row_client_list = mysql_fetch_assoc($client_list)); ?>
</table>
<br>
<p> </p>
<?php include("footer.php"); ?>
</body>
</html>
<?php
mysql_free_result($client_list);
?>