Below is a list of the Works of Nicola Porpora. It is an on-going task for which we are using many sources, not the least of which are RISM online and the New Grove Dictionary of Music and Musicians.

"; include("/hsphere/local/home/musico/shared/porporasql"); $result=mysql_query(" SELECT repertoire_heading.* FROM repertoire_heading,repertoire WHERE composer_ID='1' AND repertoire_heading.repertoire_heading_ID=repertoire.repertoire_heading_ID GROUP BY repertoire.repertoire_heading_ID ORDER BY repertoire_heading.repertoire_heading_ID "); while(list($repertoire_heading_ID,$composer_ID,$repertoire_heading)=mysql_fetch_row($result)) { print "$repertoire_heading

"; print ""; $works=mysql_query(" SELECT * FROM repertoire WHERE repertoire_heading_ID='$repertoire_heading_ID' order by title"); while(list($repertoire_ID,$repertoire_heading_ID,$title,$forces,$collection,$comments,$autograph)=mysql_fetch_row($works)) { $title=eregi_replace("XX","'",$title); $comments=eregi_replace("XX","'",$comments); $forces=eregi_replace("vv"," voices",$forces); $forces=eregi_replace("SA solo","S and/or A solo",$forces); print ""; } print "

TITLE	FORCES	COLLECTION	ADDITIONAL
$title	$forces	$collection	$comments