0) { echo "

" . $top . " " . $tables . " " . "" . $for . " " . $modulename . " ". $component . " ".$insap ."" ."©
" . $showse16 . "

"; echo "
"; while ($row = mysqli_fetch_array($result,MYSQLI_ASSOC)) { // means for each category foreach ($row as $elem) { //Prints for each category the header for the SAP-Transactions $categoriesnames = mysqli_query($link,"SELECT GEN_CATEGORIES.Category1, GEN_CATEGORIES.Category2, GEN_CATEGORIES.SAPTABLES_Description FROM GEN_CATEGORIES WHERE GEN_CATEGORIES.Language = '$userlanguage' AND GEN_CATEGORIES.Category_Nr= '$elem'"); $row = mysqli_fetch_assoc($categoriesnames); echo "" . $row["Category1"] . " " . $row["Category2"] . "" . "   " . $row["SAP_TRANSACTIONS_Description"]; echo "
"; //Prints all SAP-Tables content $saptransactionscontent=mysqli_query($link,"SELECT SAP_TRANSACTIONS.SAP_Transaction, SAP_TRANSACTIONS.SAP_Transaction_Description, SAP_TRANSACTIONS. SAP_Transaction_Comment,SAP_TRANSACTIONS.SAP_Transaction_Comment FROM SAP_TRANSACTIONS_ITEMS JOIN SAP_TRANSACTIONS ON SAP_TRANSACTIONS_ITEMS.SAP_Transaction = SAP_TRANSACTIONS.SAP_Transaction LEFT JOIN SAP_TRANSACTIONS_NOTES ON (SAP_TRANSACTIONS.SAP_Transaction = SAP_TRANSACTIONS.SAP_Transaction_Comment AND SAP_TRANSACTIONS.Language = SAP_TRANSACTIONS_NOTES.Language AND SAP_TRANSACTIONS_ITEMS.Category_Nr = SAP_TRANSACTIONS_NOTES.Category_Nr) WHERE SAP_TRANSACTIONS_ITEMS.Module_Nr ='$module' AND SAP_TRANSACTIONS_ITEMS.Category_Nr ='$elem' AND SAP_TRANSACTIONS.Language = '$userlanguage'"); } echo "
"; // Table Header echo ""; //border=0 cellpadding='0' cellspacing='2' echo ""; echo ""; echo ""; echo ""; echo ""; // Table Lines while ($row = mysqli_fetch_array($saptransactionscontent,MYSQLI_ASSOC)) { echo ""; echo ""; echo ""; echo ""; } echo "
" . $table . "" . $tablename . "" . $note . "
" . $row["SAP_Table"] . "" . $row["Description"] . "" . $row["Tablecomment"] . $row["Notes"]. "
"; echo "
"; } // wahrscheinlich nächste Kategorie echo ""; // close the header if there's at least more than 1 category } ?>