matrixspots Database Table

Table: matrixspots

Tool: Matrix
Associated Objects: MatrixSpot, MatrixSpots

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

matrixparent INT UNSIGNED NOT NULL v5

member INT UNSIGNED NOT NULL v5

level1 TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

level2 TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

level3 TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

matrix TINYINT UNSIGNED NOT NULL v5

added INT UNSIGNED NOT NULL v5

completed INT UNSIGNED NOT NULL v5

active BIT(1) NOT NULL DEFAULT 1 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 matrixspots");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $matrixparent = $resRow["matrixparent"];  //
 $member = $resRow["member"];  //
 $level1 = $resRow["level1"];  //
 $level2 = $resRow["level2"];  //
 $level3 = $resRow["level3"];  //
 $matrix = $resRow["matrix"];  //
 $added = $resRow["added"];  //
 $completed = $resRow["completed"];  //
 $active = $resRow["active"];  //
}

Other Matrix Tables

matrixcyclebonuses matrixdirectpaypassups matrixes matrixnextspots matrixque matrixspots matrixspottracking

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us