getLatestPics($lang,$mode); $tagCloudString=$categorie->tagCloudString($lang,$mode); if(!$nr){$nr=0;} $anzahlproseite="10"; /*anzahl ermitteln*/ $sql="SELECT * FROM hh_werk as w "; $sql.="INNER JOIN hh_werk_meta as wm "; $sql.="ON wm.intWerkID = w.intWerkID "; $sql.="INNER JOIN hh_metadata as m "; $sql.="ON wm.intMetaID = m.intMetaID "; $sql.="WHERE m.meta_de LIKE '" . $meta . "' "; $sql.="OR m.meta_en LIKE '" . $meta . "' "; $sql.="ORDER BY w.strDatierung"; #echo $sql . "
"; $query=mysql_query($sql); echo mysql_error(); $anzahl=mysql_num_rows($query); while($row=mysql_fetch_object($query)){ $idArray[]=$row->intWerkID; } if(count($idArray)>0){ $idString=join($idArray, ","); } /*** ende anzahl ermitteln**/ ?>

"":  "; echo ""; echo "" . $l_view_gallerie . ""; } else{ echo " "; echo "" . $l_view_tabelle . ""; echo " " . $l_view_gallerie . ""; } ?>

"; echo ""; echo " "; echo ""; echo " "; if($mode=="tabelle"){ while($row=mysql_fetch_object($query)){ //Berechnung der HÖhe/Breite in cm oder inch $breite=""; $hoehe=""; if($lang=="de" && $row->breite){ $breite=$row->breite . " cm"; $hoehe=$row->hoehe; } if($lang=="en" && $row->breite){ $hoehe=round($row->hoehe*0.394); $breite=round($row->breite*0.394); $breite.=" in."; } //BILDTräger $sql4="select strTraeger_" . $lang . " as traeger from hh_traeger where intTraegerID like '" . $row->intTraegerID ."'"; $query4=mysql_query($sql4); $traegerArray=mysql_fetch_array($query4); ?>  
id . ".jpg"; if($row->intDetail==1 && file_exists($file)){ echo ""; echo "" . $row->titel .", " .$row->datierung . ""; echo "" . $l_detail . ""; echo ""; } if($row->intDetail==0 && file_exists($file)){ echo "" . $row->titel .", " .$row->datierung . ""; } if(!file_exists($file)){ echo ""; } ?> ,
id ."'"; $materialQuery=mysql_query($sql3); //echo $sql3; echo mysql_error(); $string=""; while($row3=mysql_fetch_object($materialQuery)){ $string.= $row3->material. ", "; } if($string!=""){ $string=substr($string,0,-2); echo $string; } if($string!="" && $traegerArray[traeger]){ echo " " . $l_auf . " "; } ?>


intInstitutionID){ $sql2="select txtName_" . $lang ." as name, "; $sql2.="strOrt_" . $lang ." as ort "; $sql2.="from hh_institution where intInstitutionID like '" . $row->intInstitutionID ."'"; $query2=mysql_query($sql2); $institutionArray=mysql_fetch_array($query2); echo $institutionArray[name]; if($institutionArray[name] && $institutionArray[ort]){ echo ", "; } echo $institutionArray[ort]; } ?>

bildrecht){ echo $row->bildrecht; } else{ echo " "; } ?>
"; echo ""; $i=0; while($row=mysql_fetch_object($query)){ $file="./kat/kat" . $row->id . ".jpg"; if(file_exists($file)){ if($i==0 || $i==5 || $i==10 || $i==15 || $i==20 || $i==25 || $i==30 || $i==35 || $i==40 || $i==45 || $i==50 || $i==55){ echo ""; } echo ""; if($i==4 || $i==9 || $i==14 || $i==19 || $i==24 || $i==29 || $i==34 || $i==39 || $i==44 || $i==49 || $i==54){ echo ""; } $i++; } } echo ""; echo "
"; if($row->intDetail==1 && file_exists($file)){ echo ""; echo "" . $row->titel .", " .$row->datierung . ""; echo ""; } if($row->intDetail==0 && file_exists($file)){ echo "" . $row->titel .", " .$row->datierung . ""; } echo "
"; } ?>