<html>
<title>Personal Telco Special Ops Team Member Details</title>
<body bgcolor=#000000 text=#ffffff alink=#00ff00 vlink=#00ff00>
<?
$dbh = mysql_connect("localhost", "ops", "0ps");
       if ($dbh == FALSE) {
                if (mysql_error()) {
                    $conn_error = mysql_error();
                } else if (isset($php_errormsg)) {
                    $conn_error = $php_errormsg;
                } else {
                    $conn_error = 'Cannot connect: invalid settings.';
                }
		print "$conn_error<br>";
	}

    $result      = @mysql_query('USE ops');
    $local_query = "select * from people order by lastname";
    $result      = @mysql_query($local_query);
    $grants_cnt  = @mysql_num_rows($result);

?>

<table>
<tr><td>
<center>
<a href="index.php">
<img src="opslogo.png" border=0><br>
</a>
</center>
</tr>

<tr><td>
<table>
<tr>
<td valign=top>
<b>Team Members</b><br>

<?
   while ($usr_row = mysql_fetch_row($result)) {
    print ("<a href=\"ops.php?id=$usr_row[0]\" target=details>$usr_row[4], $usr_row[3]</a>");
    $local_query = "select * from hours where people_id='$usr_row[0]' and outtime is null";
    $clock_result      = @mysql_query($local_query);
    if ( mysql_num_rows($clock_result) > 0) {
      print ("*");
    }
    print ("<br>");
   }
?>

<td>
<!-- <center>
  <b>Special Ops Team Details</b>
 </center> -->
<iframe src="ops.php" width=620 height=380 name=details></iframe>

<td valign=top>
<b><a href="table.php" target=details>Table View</a></b><br>
</tr>
</table>
</tr>
</table>

<form action="ops.php" target=details>
<center> cli:<input size=50 name=cli></center>
</form>


<?
  mysql_close($dbh);
?>

</body>
</html>
