empty_pixel empty_pixel empty_pixel empty_pixel empty_pixel pixel_black empty_pixel
 

 

 










  =curdate() AND publish='1' order by sdate"); $travel_num=mysql_num_rows($result_t); if($travel_num>0) { ?>

e-mail )', 'contact_staff', 'scrollbars,toolbar=no,location=no,nonresizable,width=515,height=418,left=0,top=0')" class="sidebar">send email
webpage ">
phone
other phone
travel schedule ', 'travel_schedule', 'scrollbars,toolbar=no,location=no,nonresizable,width=515,height=390,left=0,top=0')">check schedule
   
0) { if($_GET["stage"]=="") echo(""); else{ echo(""); $query_cat="SELECT * FROM publications_categories ORDER BY priority"; $result_cat=mysql_query($query_cat); while($row_cat=mysql_fetch_array($result_cat)) { $pub_type=$row_cat['id']; $category=$row_cat['category']; $query="SELECT publications_main.* FROM publications_lookup,publications_main WHERE publications_lookup.publications_author_id='$id' AND publications_lookup.publications_main_id=publications_main.id AND publications_main.pub_type='$pub_type' AND publications_lookup.show='1' ORDER BY year desc, rm_number desc, id desc"; $result=mysql_query($query); $num_rows=mysql_num_rows($result); if($num_rows>"0") { echo(""); while($row=mysql_fetch_array($result)) { $pub_title=$row['pub_title']; $pub_in=$row['pub_in']; $pub_in_misc=$row['pub_in_misc']; $pub_id=$row['id']; $pub_year=$row['year']; $eds=$row["eds"]; $volume=$row["volume"]; $misc=$row["misc"]; $place=$row["place"]; $publisher=$row["publisher"]; $year=$row["year"]; $rm_number=$row["rm_number"]; $rm_fulltext=$row["rm_fulltext"]; $rm_abstract=$row["rm_abstract"]; $pub_type_r=$row["pub_type"]; $book_title=$row["book_title"]; $book_authors=$row['book_authors']; $order_info=$row['order_info']; //START AUTHOR GROUP $author_result=mysql_query("select staff.* from publications_lookup,staff where publications_lookup.publications_author_id=staff.id and publications_lookup.publications_main_id='$pub_id' ORDER BY publications_lookup.id"); $authors=""; $num_authors=mysql_num_rows($author_result); for($i=1;$i<=$num_authors;$i++) { $author_row=mysql_fetch_array($author_result); if($i=="1") { $authors.=$author_row["lastname"] . ", " . $author_row["firstname"]; if($author_row['middlename']!="") $authors.=" " . $author_row["middlename"]; } else $authors.=$author_row["firstname"] . " " . $author_row["middlename"] . " " . $author_row["lastname"]; if($num_authors>1){ if($i==$num_authors-1) $authors.=" & "; elseif($i!=$num_authors) $authors.=", "; } }// END AUTHOR GROUP $month_w=return_month($month); include("../publications/pub_string.php"); echo(""); } } } } } } ?>

Selected publications by $firstname $middlename $lastname


Selected publications by $firstname $middlename $lastname


[close]


$category
"); echo("$pub_string"); echo("

  pixel black
" width="176" height="176">