// Login to database
$hostname="db30.pair.com";
$username = "wyattr_r";
$password = "Ellread23 ";
$db = mysql_pconnect($hostname,$username,$password);
$database="wyattr_ellison";
?>
Information Needed for Bibliographic Database
Major Stuff Needed
Book Editions for the 80's and 90's
ISBNs for editions without them
Update of/Additions to of list of essays written after 1973
//Display query results ?>
// Missing year - Build query string
$sql = "SELECT * from piece where first_pub = 0 AND Type <> 'Break'";
$rc = mysql_db_query($database,$sql,$db);
if($rc && mysql_num_rows($rc) > 0) {
echo "Pieces with no year published
\n";
while ($row2 = mysql_fetch_array($rc)) {
// Special coding for sections
echo "$row2[title]     - $row2[subType], $row2[first_pub]";
IF ($show_pc_by) echo " By HE: $row2[by_he]";
echo "
\n";
IF ($show_pc_first && $row2[first_appearance]>" ")
echo "First Appearance: $row2[first_appearance]
";
IF ($show_pc_notepc=="on" && $row2[15]>" ")
echo "  $row2[15]
\n";
IF ($show_pc_noteed=="on" && $row2[3]>" ")
echo "  $row2[3]
\n";
}
}
// Missing pub - Build query string
$sql = "SELECT * from piece where first_appearance = '' AND Type <> 'Break'";
$rc = mysql_db_query($database,$sql,$db);
if($rc && mysql_num_rows($rc) > 0) {
echo "Pieces with no first appearance
\n";
while ($row2 = mysql_fetch_array($rc)) {
// Special coding for sections
echo "$row2[title]     - $row2[subType], $row2[first_pub]";
IF ($show_pc_by) echo " By HE: $row2[by_he]";
echo "
\n";
IF ($show_pc_first && $row2[first_appearance]>" ")
echo "First Appearance: $row2[first_appearance]
";
IF ($show_pc_notepc=="on" && $row2[15]>" ")
echo "  $row2[15]
\n";
IF ($show_pc_noteed=="on" && $row2[3]>" ")
echo "  $row2[3]
\n";
}
}
//end page
INCLUDE("html_end.htm");
exit;
?>