Debug: Sections für Order ID $order_id"; // SQL-Abfrage 1: Alle Einträge für diese Order $sql1 = "SELECT * FROM ".MAIN_DB_PREFIX."facture_lines_manager"; $sql1 .= " WHERE ".$tables['fk_parent']." = ".(int)$order_id; $sql1 .= " ORDER BY line_order"; echo "

SQL 1: Alle Einträge

"; echo "

".htmlspecialchars($sql1)."

"; $resql1 = $db->query($sql1); if ($resql1) { echo ""; while ($obj = $db->fetch_object($resql1)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

rowid	fk_commande	document_type	line_type	title	line_order
".$obj->rowid."	".$obj->fk_commande."	".$obj->document_type."	".$obj->line_type."	".$obj->title."	".$obj->line_order."

"; } else { echo "

Fehler: ".$db->lasterror()."

"; } // SQL-Abfrage 2: Nur Sections mit document_type $sql2 = "SELECT * FROM ".MAIN_DB_PREFIX."facture_lines_manager"; $sql2 .= " WHERE ".$tables['fk_parent']." = ".(int)$order_id; $sql2 .= " AND document_type = '".$db->escape($docType)."'"; $sql2 .= " AND line_type = 'section'"; $sql2 .= " ORDER BY line_order"; echo "

SQL 2: Sections mit document_type = 'order'

"; echo "

".htmlspecialchars($sql2)."

"; $resql2 = $db->query($sql2); if ($resql2) { $num = $db->num_rows($resql2); echo "

Anzahl gefunden: $num

"; echo ""; while ($obj = $db->fetch_object($resql2)) { echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

rowid	title	line_order
".$obj->rowid."	".$obj->title."	".$obj->line_order."

"; } else { echo "

Fehler: ".$db->lasterror()."

"; }