
<?php

require("includes/internal_top_100.inc");
require("includes/nav_home.inc");

# CONNECT TO SERVER
$host = "ovid21.u.washington.edu:11116";
$user = "root";
$pass = "VJSalr";

$db = mysql_pconnect($host, $user, $pass) || die("Cannot connect to server: $host, user: $user");
mysql_select_db('seaptc');


print "<h4>Seattle STD/HIV Prevention Training Center Faculty</h4>\n";
print "<div align=\"center\">\n";

print "<div id=\"pull\">\n";

$myQry = "SELECT * FROM faculty ORDER BY lName ASC";
$done = mysql_query($myQry);

if(mysql_num_rows($done) > 0){
	
	while($row = mysql_fetch_array($done)){
		print "<p><br><table width=\"95%\"\ cellspacing=\"2\" cellpadding=\"3\" border=\"0\" class=\"content\">\n";
		print "<tr><td bgcolor=\"#666666\" colspan=\"3\"><b style=\"color: #ffffff; font-size: 14px\">" . $row['lName'] . ", " . $row['fName'] . "&nbsp;&nbsp;&mdash;&nbsp;&nbsp;" . $row['degree']. "</td></tr>\n";
		print "<tr>\n";
		print "<td bgcolor=\"#E7E6E6\" width=\"35%\" valign=\"top\"><b>Focus:</b> " . $row['expertise'] . "</td>";
		print "<td bgcolor=\"#E7E6E6\" width=\"55%\" valign=\"top\">" . $row['title'] . "</td>";
		($row['email']) ? print "<td bgcolor=\"#E7E6E6\" width=\"10%\" valign=\"top\"><a href=\"mailto:" . $row['email'] . "\">email</a></td>" :  print "<td bgcolor=\"#E7E6E6\">&nbsp;</td>";
		//($row['website']) ? print "<td bgcolor=\"#E7E6E6\" width=\"10%\" valign=\"top\">[ <a href=\"" . $row['website'] . "\">website</a> ]</td>" :  print "<td bgcolor=\"#E7E6E6\">&nbsp;</td>";
		print "</tr>\n";
		print "</td></tr>\n";
		print "</table>\n";
		
		}
	}


print   ('

        <div class="footer">
        <hr>
          <a target="_top" class="footer_nav" href="index.shtml">Home</a>
          <a target="_top" class="footer_nav" href="contact_us.php">Contact Us</a><a href="http://depts.washington.edu/nnptc/" target="_blank"><img src="/seaptc/images/nnptc_logo.gif" border="0" align="middle" hspace="75"></a>
        </div>
      <!-- END CONTENT -->
      </div>');

print "</div>\n";

print "</div>\n";

?>

    </td>
  </tr>
</table>
<script language="javascript">
    <!--
    //Determine Live State Buttons
      for (i=0;i<aryNavImg.length;i++)
      {
///        var thisImg = eval("document." + aryNavImg[i]);

        if (sPage.indexOf(aryNavImg[i]) != -1)
        {
///          var thisImg = eval("document." + aryNavImg[i]);
//          thisImg.src = "images/btn_" + aryNavImg[i] + "_live.gif";
///          thisImg.color = "#FFFFFF"; //strLiveColor;
          liveStateColor(getElementObj(aryNavImg[i]), strLiveColor);
        }
      }
    //-->
  </script>
  <script language="javascript" src="functions/define_nav.js"></script>
</body>
</html>
