//Anmelden bei mySQL $link = mysql_connect("127.0.0.1","web0","13t25L"); $query = "USE usr_web0_1"; mysql_query($query,$link); function schleifeActors($link) { // $query = "SELECT * FROM bilderimages where pi='146_18-2003'"; $query = "SELECT * FROM suchelistecache_SH where kat=200 and InstAdrNr=". $_GET["inst"]. " ORDER BY bez_1"; $z = 0; // echo $query; echo "
"; echo "200.". $row[id]; echo " | "; echo ""; echo $row[bez_1]; echo " | "; echo ""; echo $row[Anzahl_lokal]; echo " | "; $query = "SELECT * FROM kat200 where cat_id=". $row[id]; $resultA = mysql_query($query,$link); $rowActor = mysql_fetch_assoc($resultA); $temp==""; if (!($rowActor[_int3]==0)) $temp=$rowActor[_int3]; echo ""; echo "geboren: ". $temp; echo " | "; $temp=""; if (!($rowActor[_int6]==0)) $temp=$rowActor[_int6]; echo ""; echo "gestorben: ". $temp; echo " | "; $temp=""; if ($rowActor[_int11]==1) $temp="VG-Bild"; elseif ($rowActor[_int11]==2) $temp="Gemeinfrei"; elseif ($rowActor[_int11]==3) $temp="Künstler"; elseif ($rowActor[_int11]==4) $temp="Rechtsnachfolger"; echo ""; echo "Urheberrecht: ". $temp; echo " | "; $temp=""; if ($rowActor[_int14]==1) $temp="ja"; if ($rowActor[_int14]==2) $temp="nein"; echo ""; echo "freigeben MPSH: ". $temp; echo " | "; $temp=""; mysql_free_result($resultA); echo "