// show titles
  elseif($sqlType=="title") {
    // just in case it is still here: drop tmpTitleIDs
    mysql_query("DROP TABLE IF EXISTS tmpTitleIDs");
    // create new table with title IDs
    mysql_query($sql);
    echo $sql or die(mysql_error());
    if(!mysql_affected_rows()) {
      echo "<p>No results.\n";
    }
    else {
      // querys for complete title data
      $result1 = mysql_query
        ("SELECT titles.titleID AS titleID, " .
         "       titles.title AS title, " .
         "       titles.subtitle AS subtitle, " .
         "       titles.edition AS edition, " .
         "       titles.year, " .
         "       titles.isbn, " .
         "       titles.comment, " .
         "       publishers.publName AS publisher, " .
         "       publishers.publID, " .
         "       categories.catName AS category, " .
         "       languages.langName AS language " .
                "      FROM titles JOIN tmpTitleIDs" .
                  "     LEFT JOIN categories ON titles.catID = categories.catID " .
         "     LEFT JOIN languages ON titles.langID = languages.langID " .
                  "     LEFT JOIN publishers ON titles.publID = publishers.publID " .
         "WHERE titles.titleID = tmpTitleIDs.titleID" );

      
      // query for authors
      $result2 = mysql_query
        ("SELECT tmpTitleIDs.titleID, rel_title_author.authID, " .
         "       authName AS author " .
         "FROM authors, rel_title_author, tmpTitleIDs " .
         "WHERE authors.authID = rel_title_author.authID " .
         "  AND rel_title_author.titleID = tmpTitleIDs.titleID " .
         "ORDER BY rel_title_author.authNr, authName");
       
       
       // Query for standort
       $result3 = mysql_query
       (" SELECT standort.name from standort," .
       "WHERE titles.standortID = standort.standortID");////<-DA STIMMT WAS NICHT
       
       
      // copy authors into array
      while($row = mysql_fetch_object($result2)) {
        // seperate authors by a comma
        if($authors[$row->titleID]) 
          $authors[$row->titleID] .= ", ";
        // add author to author's list; because of ORDER BY clause
        // in the SQL statement the authors are ordered correctly
        $tmp = build_href("./find.php", 
                          "sqlType=title&authID=$row->authID", 
                          last_name_last($row->author));
        $authors[$row->titleID] .= $tmp;
      }
      
echo '<form action="ergebnisse.php" method="post">'; //testzeile


      // show title list
      echo "<hr><ul>\n";
      $titlecount=0;
      while($row = mysql_fetch_object($result1)) {
        $titlecount++;
        if($titlecount<=$pagesize) {
          if($row->publisher)
            $publref = build_href("./find.php", 
                                  "sqlType=title&publID=$row->publID", 
                                  $row->publisher);
                   // title
          echo "<p><li>", $authors[$row->titleID], ": ",
            "<b>", htmlentities($row->title), "</b>",
            $row->subtitle ? ", " . htmlentities($row->subtitle) . " " : "",
            $row->publisher || $row->year ? "<br>" : "", 
            $row->publisher ? $publref : "",
            $row->year ? ", " . htmlentities($row->year) . " " : "",
            $row->edition ? "<br>Edition: " . htmlentities($row->edition) ." " : "",
            $row->isbn ? "<br>Buchnummer: " . htmlentities($row->isbn) . " " : "",
            $row->language ? "<br>Sprache: <i>" . htmlentities($row->language) . "</i> " : "",
            $row->category ? "<br>Kategorie: <i>" . htmlentities($row->category) . "</i> " : "",
            $row->comment ? "<br>Kommentar: <i>" . htmlentities($row->comment) . "</i> " : "",
                        "</li>\n";
        
        }
         $standortcount=0;
      while ($row = mysql_fetch_object($result3)){///<- UND HIER WIRD DER FEHLER GEMELDET
      	 $standortcount++;
      	 echo $row->standort ? "<br>Standort: <i>" . htmlentities($row->standort) ."</i>" :"",
      	 "</li>\n";
      	}
      	 
      echo '<br><b>Buch entleihen: </b><input type="checkbox" name="Marker[]" value="'.$titleID.'"></br>';
            			     			
}     
      echo 'Standort : ';
     build_select_list("formStandort",
    	"SELECT StandortID, name FROM Standort " .
    		"ORDER BY name", $formStandort); 
    
    }
      if($result1 and $result2)
    	echo '<input type="submit"  value="Auswahl bestätigen">';