%s \n", $row->authname ); else printf("

%s \n", $row->photo,$row->authname ); printf("%s

E-mail: %s

Publications available on IDEA:

\n"); $query2 = sprintf("select * from bnw_articles where authorid=%d order by pub_date desc", $id); $result2 = mysql_query($query2) or die("4 There has been an error accessing the database. Please try again later. \n\n"); if(mysql_num_rows($result2)>0) { for ($i=0; $i < mysql_num_rows($result2); $i++) { if(!mysql_data_seek ($result2, $i)) { printf ("
Error seeking row %d", $i); continue; } if(!($row2=mysql_fetch_object($result2))) continue; printf("%s\n", getarticleinfo($row2->articleid, 0, 0, 1, 1)); } } $query2 = sprintf("select * from bnw_supplements where authorid=%d order by pub_date desc", $id); $result2 = mysql_query($query2) or die("4 There has been an error accessing the database. Please try again later. \n\n"); if(mysql_num_rows($result2)>0) { for ($i=0; $i < mysql_num_rows($result2); $i++) { if(!mysql_data_seek ($result2, $i)) { printf ("
Error seeking row %d", $i); continue; } if(!($row2=mysql_fetch_object($result2))) continue; printf("%s
\n", $row2->articleid, $row2->title); } } printf("

The following authors have contributed their work to IDEA:

\n"); $query = sprintf("select * from bnw_authors order by authsortname"); $result = mysql_query($query) or die("4 There has been an error accessing the database. Please try again later. \n\n"); for ($i=0; $i < mysql_num_rows($result); $i++) { if(!mysql_data_seek ($result, $i)) { printf ("
• Error seeking row %d", $i); continue; } if(!($row=mysql_fetch_object($result))) continue; if ($row->authsortname > '') { printf("
• %s",$row->authorid, $row->authsortname ); } } } printf("