Ausgabe trotz leere Tabellen

[McB_sser]

für die es vieleicht interessiert hier die aufsplittung.

PHP-Code:

$sql = "SELECT
                        ID, Titel, Beschreibung
                     FROM
                        lehrmaterial_einsicht
                     ORDER BY
                        ID ASC";
            $query = mysql_query($sql) or die (mysql_error());
            while($DB = mysql_fetch_array($query))
               {
                  $Anzeigen = false;
                  $sql2 = "SELECT
                              ID, lehrmaterial_einsicht_ID, sichtbar
                           FROM
                              fotos
                           WHERE
                              lehrmaterial_einsicht_ID = '".$DB['ID']."'
                              AND sichtbar = '1'
                           LIMIT
                              1";
                  $query2 = mysql_query($sql2) or die (mysql_error());
                  while($DB2 = mysql_fetch_array($query2))
                     {$Anzeigen = true;};

                  $sql2 = "SELECT
                              account_ID, lehrmaterial_einsicht_ID
                           FROM
                              account_has_lehrmaterial_einsicht
                           WHERE
                                  account_ID = '".$Account_ID."'
                              AND lehrmaterial_einsicht_ID = '".$DB['ID']."'
                           LIMIT
                              1";
                  $query2 = mysql_query($sql2) or die (mysql_error());
                  while($DB2 = mysql_fetch_array($query2))
                     {$Anzeigen = true;};
                     
                  $sql2 = "SELECT
                              KhLE.klasse_ID, KhLE.lehrmaterial_einsicht_ID,
                              AhK.account_ID, AhK.klasse_ID
                           FROM
                              klasse_has_lehrmaterial_einsicht AS KhLE,
                              account_has_klasse AS AhK
                           WHERE
                                  AhK.account_ID = '".$Account_ID."'
                              AND KhLE.klasse_ID = AhK.klasse_ID
                              AND lehrmaterial_einsicht_ID = '".$DB['ID']."'
                           LIMIT
                              1";
                  $query2 = mysql_query($sql2) or die (mysql_error());
                  while($DB2 = mysql_fetch_array($query2))
                     {$Anzeigen = true;};
                  if($Anzeigen === true)
                     {
                        $lehrmaterial_einsicht_array[$m]['ID'] = $DB['ID'];
                        $lehrmaterial_einsicht_array[$m]['Titel'] = $DB['Titel'];
                        $m++;
                     };
               }; 


Da ist es wurst ob eine der Tabellen leer ist.

Edit:
das Obere ist für das menü und das untere für die fotos an sich

PHP-Code:

$sql = "SELECT
                             ID, lehrmaterial_einsicht_ID, Titel,
                             Beschreibung, URL, Zeitstempel,
                             Text, sichtbar, Vorschau_Foto,
                             Foto
                          FROM
                             fotos
                          WHERE
                             lehrmaterial_einsicht_ID = '".$GET_lehrmaterial_einsicht_ID."'
                          ORDER BY
                             Zeitstempel DESC";
                 $query = mysql_query($sql) or die (mysql_error());
                 while($DB = mysql_fetch_array($query))
                    {
                       $Anzeigen = false;
                       $sql2 = "SELECT
                                   ID, lehrmaterial_einsicht_ID, sichtbar
                                FROM
                                   fotos
                                WHERE
                                       ID = '".$DB['ID']."'
                                   AND lehrmaterial_einsicht_ID = '".$DB['lehrmaterial_einsicht_ID']."'
                                   AND sichtbar = '1'
                                LIMIT
                                   1";
                       $query2 = mysql_query($sql2) or die (mysql_error());
                       while($DB2 = mysql_fetch_array($query2))
                          {$Anzeigen = true;};

                       $sql2 = "SELECT
                                   account_ID, lehrmaterial_einsicht_ID
                                FROM
                                   account_has_lehrmaterial_einsicht
                                WHERE
                                       account_ID = '".$Account_ID."'
                                   AND lehrmaterial_einsicht_ID = '".$DB['lehrmaterial_einsicht_ID']."'
                                LIMIT
                                   1";
                       $query2 = mysql_query($sql2) or die (mysql_error());
                       while($DB2 = mysql_fetch_array($query2))
                          {$Anzeigen = true;};

                       $sql2 = "SELECT
                                   KhLE.klasse_ID, KhLE.lehrmaterial_einsicht_ID,
                                   AhK.account_ID, AhK.klasse_ID
                                FROM
                                   klasse_has_lehrmaterial_einsicht AS KhLE,
                                   account_has_klasse AS AhK
                                WHERE
                                       AhK.account_ID = '".$Account_ID."'
                                   AND KhLE.klasse_ID = AhK.klasse_ID
                                   AND lehrmaterial_einsicht_ID = '".$DB['lehrmaterial_einsicht_ID']."'
                                LIMIT
                                   1";
                       $query2 = mysql_query($sql2) or die (mysql_error());
                       while($DB2 = mysql_fetch_array($query2))
                          {$Anzeigen = true;};
                       if($Anzeigen === true)
                          {
                             $Tabellenzeilen[$m]['ID'] = $DB['ID'];
                             $Tabellenzeilen[$m]['Titel'] = $DB['Titel'];
                             $Tabellenzeilen[$m]['Beschreibung'] = $DB['Beschreibung'];
                             $Tabellenzeilen[$m]['Zeitstempel'] = $DB['Zeitstempel'];
                             $Tabellenzeilen[$m]['LE_ID'] = $DB['lehrmaterial_einsicht_ID'];
                             $m++;
                          };
                    };