0) {
echo "
" . $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 "
"; } // wahrscheinlich nächste Kategorie echo ""; // close the header if there's at least more than 1 category } ?>
" . $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 "
| " . $table . " | "; echo "" . $tablename . " | "; echo "" . $note . " | "; echo "" . $row["SAP_Table"] . " | "; echo "" . $row["Description"] . " | "; echo "" . $row["Tablecomment"] . $row["Notes"]. " | "; echo ""; } echo "
"; } // wahrscheinlich nächste Kategorie echo ""; // close the header if there's at least more than 1 category } ?>
Buchempfehlungen
Projektmanagement mit SAP Projektsystem