Location: PHPKode > projects > Tech Tickets > technician/tt_view_clients_select.php
<?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>&nbsp;</p>
	  
<?php include("footer.php"); ?>

</body>
</html>
<?php
mysql_free_result($client_list);
?>




Return current item: Tech Tickets