offers Database Table

Table: offers

Tool: Offers

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

added INT UNSIGNED NOT NULL v5

title VARCHAR(255) NOT NULL v5

offertemplate INT UNSIGNED NOT NULL v5

type TINYINT UNSIGNED NOT NULL v5

ismember BIT(1) NOT NULL DEFAULT 1 v5

visitorgroup SMALL INT UNSIGNED NOT NULL DEFAULT 0 v5

body TEXT NOT NULL v5

bodytype TINYINT UNSIGNED NOT NULL 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 offers");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $added = $resRow["added"];  //
 $title = $resRow["title"];  //
 $offertemplate = $resRow["offertemplate"];  //
 $type = $resRow["type"];  //
 $ismember = $resRow["ismember"];  //
 $visitorgroup = $resRow["visitorgroup"];  //
 $body = $resRow["body"];  //
 $bodytype = $resRow["bodytype"];  //
}

Other Offers Tables

offers offerstats offertemplates

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us