<thead> <?php echo create_table_header($result); ?> </thead> <tbody> <?php echo create_table_body($result, "payments.php"); ?> </tbody> </table> <?php $query = "SELECT * FROM TransactionItems WHERE TrxID=" . intval($_GET['id']); $result = mysql_query($query) or die($query . "<br />" . mysql_error()); ?> <h2>Transaction Items</h2> <table> <thead> <?php echo create_table_header($result); ?> </thead> <tbody> <?php echo create_table_body($result, "trxitem.php"); ?> </tbody> </table> <?php } echo footer();
* * This file is to help people explore PO's. * * Created by Rodolphe Courtier */ require_once 'config.php'; $query_extra = ""; if (isset($_GET['id'])) { $query_extra = "WHERE ID=" . $_GET['id']; } $query = "SELECT * FROM PurchaseOrderItems " . $query_extra . " ORDER BY ID DESC LIMIT 100"; $result = mysql_query($query) or die($query . "<br />" . mysql_error()); ?> <?php echo head("Purchase Order Items", basename(__FILE__)); ?> <table> <thead> <?php echo create_table_header($result); ?> </thead> <tbody> <?php echo create_table_body($result, basename(__FILE__)); ?> </tbody> </table> <?php echo footer();
<?php echo create_table_header($result); ?> </thead> <tbody> <?php echo create_table_body($result, basename(__FILE__)); ?> </tbody> </table> <?php if (isset($_GET['id'])) { $query = "SELECT * FROM PurchaseOrderReceiptItems WHERE ReceiptID=" . $_GET['id']; $result = mysql_query($query) or die($query . "<br />" . mysql_error()); ?> <h2>Purchase Order Receipt Items</h2> <table> <thead> <?php echo create_table_header($result); ?> </thead> <tbody> <?php echo create_table_body($result, "poreceiptitem.php"); ?> </tbody> </table> <?php } echo footer();