|
News & Information
Directory
include("../database/dbinfo_inc.php");
$table_people = $table_people;
$table_groups = $table_groups;
$table_people_groups = $table_people_groups;
$table_width = 460;
function future_date($date) {
$year_date = substr($date,0,4); $month_date = substr($date,5,2); $day_date = substr($date,8,2);
$year_today = date(Y); $month_today = date(m); $day_today = date(d);
if ($year_date > $year_today) { $future = "yes";}
if ($year_date < $year_today) { $future = "no";}
if ($year_date == $year_today) {
if ($month_date > $month_today) { $future = "yes";}
if ($month_date < $month_today) { $future = "no";}
if ($month_date == $month_today) {
if ($day_date > $day_today) { $future = "yes";}
if ($day_date < $day_today) { $future = "no";}
if ($day_today == $day_date) { $future = "yes";}
}
}
return $future;
}
?>
" bordercolor="#666666">
NAME
$num_rows=0;
mysql_connect($mysqlhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database $database");
$result = mysql_query("SELECT * FROM $table_people ORDER BY 'name_last' ASC, 'name_first' ASC");
$num_rows = mysql_num_rows($result);
mysql_close ();
//if ($num_rows == 1)
// { echo "($num_rows person";}
// else {echo "($num_rows people";}
// echo " found)";
?> |
EMAIL |
$last_updated_info=strtotime(0000-00-00);
$i_people=0;
while ($i_people < $num_rows) {
$name_first=mysql_result($result, $i_people, "name_first");
$name_last=mysql_result($result, $i_people, "name_last");
$name_preferred=mysql_result($result, $i_people,"name_preferred");
if ($name_preferred) {$name_to_use =$name_preferred;}
else {$name_to_use =$name_first;}
$date_end_vrd=mysql_result($result, $i_people, "date_end_vrd");
$email_1=mysql_result($result, $i_people, "email_1");
$email_2=mysql_result($result, $i_people, "email_2");
$date_ud=mysql_result($result, $i_people, "date_ud");
if ((strtotime($date_ud)) > $last_updated_info){ //check to see what most recent update to the people db was
$last_updated_info = strtotime($date_ud);
}else{}
if (($date_end_vrd == '0000-00-00') || (future_date($date_end_vrd) == "yes")){
?>
echo "$name_last, $name_to_use"; ?> |
"> echo "$email_1"; ?>
"> echo "$email_2"; ?> |
}
else{}
++$i_people;
}
?>
(updated... echo date('F j, Y', $last_updated_info); ?>)
|
|
News & Information
Vascular Research Division
Department of Pathology
7th Floor - Room 730
Harvard NRB
77 Avenue Louis Pasteur
Boston, MA 02115
Tel# (617) 525-4307
Fax# (617) 525-4329
Fax# (617) 525-4326
|
|