">

"; $queryInfoType = "SELECT TypeID,Name".$qLang." FROM infoformtypes "; $resultInfoType = mysql_query($queryInfoType); echo""; if(!$resultInfoType || mysql_num_rows($resultInfoType) <= 0) { echo""; } else { echo""; } $queryInfoLang = "SELECT IL.LanguageID, IL.Name".$qLang." FROM infoformlanguage IL INNER JOIN infoformtypes_language IL_T "; $queryInfoLang.= "ON IL.LanguageID=IL_T.LanguageID AND IL_T.TypeID=$selInfoType ORDER BY IL.LanguageID"; $resultInfoLang = mysql_query($queryInfoLang); if($resultInfoLang) { echo" "; } $queryInfoComp = "SELECT IC.CompositionID,IC.Name".$qLang." FROM infoformcompositions IC INNER JOIN infoformcompositions_types IC_T ON IC.CompositionID=IC_T.CompositionID AND IC_T.TypeID=$selInfoType ORDER BY IC.CompositionID"; $queryInfoTheme = "SELECT IT.ThemeID,IT.Name".$qLang." FROM infoformthemes IT INNER JOIN infoformthemes_types IT_T ON IT.ThemeID=IT_T.ThemeID AND IT_T.TypeID=$selInfoType ORDER BY IT.ThemeID"; $resultInfoComp = mysql_query($queryInfoComp); $resultInfoTheme = mysql_query($queryInfoTheme); echo " $tInfo       $tAll $tNoItems "; $i = 0; while($rowInfoType = mysql_fetch_row($resultInfoType)) { if($i == 0 && $selInfoType == 0) { echo"".htmlspecialchars($rowInfoType[1]).""; $selInfoType = $rowInfoType[0]; $IsFirst = false; } else { if($rowInfoType[0] == $selInfoType) echo"".htmlspecialchars($rowInfoType[1]).""; else echo"".htmlspecialchars($rowInfoType[1]).""; } $i++; } echo" $tTypes "; $cnt = mysql_num_rows($resultInfoLang); for ($i = 0; $i < $cnt; $i++) { echo"".htmlspecialchars(mysql_result($resultInfoLang,$i,"IL.Name".$qLang)).""; }; /*IL.Name".$qLang while($rowInfoLang = mysql_fetch_row($resultInfoLang)) { echo"".htmlspecialchars($rowInfoLang[1]).""; } */ echo" $tInfoLanguage

"; if($resultInfoComp) { echo""; } if($resultInfoTheme) { echo""; } echo" $tInfoComp $tInfoTheme "; if($resultInfoComp == NULL || mysql_num_rows($resultInfoComp) <= 0) ; else { echo " $tAll"; } echo" "; if($resultInfoTheme == NULL || mysql_num_rows($resultInfoTheme) <= 0) ; else { echo" $tAll"; } echo" "; while($rowInfoComp = mysql_fetch_row($resultInfoComp)) { echo"".htmlspecialchars($rowInfoComp[1]).""; } echo" "; while($rowInfoTheme = mysql_fetch_row($resultInfoTheme)) { echo"".htmlspecialchars($rowInfoTheme[1]).""; } echo" $tSelText

"; ?> selCh(); "; ?>