<table width="200" border="0" align="center">
  <tr>
    <td><a href="http://ul.uc.edu/uclit/teaming/helpcalls/sort_helpcalls.php"><img src="sort3.jpg" alt="Sort" width="120" height="50" border="0" /></a></td>
    <td><a href="http://ul.uc.edu/uclit/teaming/helpcalls/show_tech.php"><img src="Check3.jpg" alt="Check" width="120" height="50" border="0" /></a></td>
    <td><a href="http://ul.uc.edu/uclit/teaming/helpcalls/show_hreport.php"><img src="Report3.jpg" alt="Report" width="120" height="50" border="0" /></a></td>
    <td><a href="http://ul.uc.edu/uclit/teaming/helpcalls/show_calls.php"><img src="Knowledge3.jpg" alt="Knowledge" width="120" height="50" border="0" /></a></td>
  </tr>
</table>

<?php	
	include('/var/www/html/uclit/protected/connections/db_help.php');
		
	//Select a database
	$db1 = mysql_select_db('helpcalls', $helpConn) or die("Couldn't select helpcalls database ");
	
	//SQL statement	
	$query = "SELECT tech_name FROM techs WHERE status != 0 ORDER BY tech_name";
	
	//execute SQL query and get result
	$sql_result = mysql_query($query, $helpConn) or die ("Couldn't execute query. <p>$query</p>");
	
	if (!$sql_result) 
	{
		echo "<p>couldn't get list! $sql_result</p>";
	}
	else
	{
?>
<!-- <H1>Select a Technician</H1> -->

<FORM METHOD='post' ACTION='sel_by_tech.php'>

  <TABLE CELLSPACING='3' CELLPADDING='3'>
<p>&nbsp;</p>
    <TR>
      <TD height='125' VALIGN=TOP><P><STRONG>Administrator Name:</STRONG><BR>
          <select name='help_tech'>
            <option selected value=''>Select.......</option>
<?php
				while ($row = @mysql_fetch_array($sql_result)) 
				{
					$tech_name = $row[tech_name];
					echo "<option>$tech_name</option>";
				}
echo"
          </select>
        <P> 
          <INPUT TYPE='SUBMIT' NAME='submit' VALUE='Query Administrator'>
        </P></TD>
    </TR>
  </TABLE>";
	}
?>