4 "; } elseif ($number == 8) { $minimum = " having count(kw.fID) > 8 "; } elseif ($number == 16) { $minimum = " having count(kw.fID) > 16 "; } elseif ($number == 24) { $minimum = " having count(kw.fID) > 24 "; } elseif ($number == 48) { $minimum = " having count(kw.fID) > 48 "; } elseif ($number == 100) { $minimum = " having count(kw.fID) > 100 "; } if ($main == "") { //////////////////////////////////////////////////////////////////////////////// // ALLE KEYWORDS AUSLESEN $selectKeywords = "select kw.fTitle as Keyword, fokw.frKeywordID as KeywordID, count(fokw.frKeywordID) as KeyNr, fokw.frFotoID, fo.fID, fo.fPublic, fows.frFotoID, fows.frWebsiteID, kw.fStatus from comKeyword kw inner join tb_Foto_Keyword fokw on fokw.frKeywordID = kw.fID inner join tb_Foto fo on fo.fID = fokw.frFotoID left outer join tb_Foto_Website fows on fows.frFotoID = fo.fID where ".$basic." and kw.frTypeID = 0 group by kw.fID".$minimum.$sortorder; $keywordsData = @mysql_query($selectKeywords,$dbh); //////////////////////////////////////////////////////////////////////////////// // ZUFÄLLIGES KEYWORD AUSLESEN $selectRandomKeyword = "select kw.fTitle as Keyword, fokw.frKeywordID as KeywordID, count(fokw.frKeywordID) as KeyNr, fokw.frFotoID, fo.fID, fo.fPublic, fows.frFotoID, fows.frWebsiteID, kw.fStatus from comKeyword kw inner join tb_Foto_Keyword fokw on fokw.frKeywordID = kw.fID inner join tb_Foto fo on fo.fID = fokw.frFotoID left outer join tb_Foto_Website fows on fows.frFotoID = fo.fID where ".$basic." and kw.frTypeID = 0 group by kw.fID having count(kw.fID) > 4 order by rand()"; $randomKeywordData = @mysql_query($selectRandomKeyword,$dbh); $randomKeyword = @mysql_result($randomKeywordData, 0, 0); $randomKeywordID = @mysql_result($randomKeywordData, 0, 1); } else { //////////////////////////////////////////////////////////////////////////////// // ALLE KEYWORDS AUSLESEN $selectKeywords = "select kw.fTitle as Keyword, fokw.frKeywordID as KeywordID, count(fokw.frKeywordID) as KeyNr, fokw.frFotoID, fo.fID, fo.fPublic, fows.frFotoID, fows.frWebsiteID, kw.fStatus, fokw.fStatusID from comKeyword kw inner join tb_Foto_Keyword fokw on fokw.frKeywordID = kw.fID inner join tb_Foto fo on fo.fID = fokw.frFotoID left outer join tb_Foto_Website fows on fows.frFotoID = fo.fID where ".$basic." and kw.frTypeID = 0 and fokw.fStatusID = 1 group by kw.fID".$minimum.$sortorder; $keywordsData = @mysql_query($selectKeywords,$dbh); //////////////////////////////////////////////////////////////////////////////// // ZUFÄLLIGES KEYWORD AUSLESEN $selectRandomKeyword = "select kw.fTitle as Keyword, fokw.frKeywordID as KeywordID, count(fokw.frKeywordID) as KeyNr, fokw.frFotoID, fo.fID, fo.fPublic, fows.frFotoID, fows.frWebsiteID, kw.fStatus, fokw.fStatusID from comKeyword kw inner join tb_Foto_Keyword fokw on fokw.frKeywordID = kw.fID inner join tb_Foto fo on fo.fID = fokw.frFotoID left outer join tb_Foto_Website fows on fows.frFotoID = fo.fID where ".$basic." and kw.frTypeID = 0 and fokw.fStatusID = 1 group by kw.fID having count(kw.fID) > 4 order by rand()"; $randomKeywordData = @mysql_query($selectRandomKeyword,$dbh); $randomKeyword = @mysql_result($randomKeywordData, 0, 0); $randomKeywordID = @mysql_result($randomKeywordData, 0, 1); } ?> - Alle <? if ($main == ""): ?>Stichworte<? else: ?>Hauptmotive<? endif; ?>