commissions Database Table

Table: commissions

Tool: Commission Tracking
Associated Objects: Commissions, Commission

Fields

id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT v5

member INT UNSIGNED NOT NULL v5

amount DECIMAL(8,2) NOT NULL v5

added INT UNSIGNED NOT NULL v5

payment INT UNSIGNED NOT NULL DEFAULT 0 v5

directpay BIT(1) NOT NULL DEFAULT 0 v5

refunded TINYINT NOT NULL DEFAULT 0 v5

Example PHP Usage

The following php example is designed for the main folder: /

<?php
include("admin/load/nosession.php");  //Load Database Connection

$results = $mysqli->query("SELECT * FROM commissions");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $amount = $resRow["amount"];  //
 $added = $resRow["added"];  //
 $payment = $resRow["payment"];  //
 $directpay = $resRow["directpay"];  //
 $refunded = $resRow["refunded"];  //
}

Other Commission Tracking Tables

commissionholdings commissions commissiontierrollups commissiontiers membershipbonuses membershipupgrade payouts

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us