smsque Database Table

Table: smsque

Tool: SMS/Voice Marketing
Associated Objects: SMSQue, SMSQues

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

member INT UNSIGNED NOT NULL v5

phone VARCHAR(20) NOT NULL v5

type TINYINT UNSIGNED NOT NULL v5

message VARCHAR(255) NOT NULL v5

added INT UNSIGNED NOT NULL DEFAULT 0 v5

image VARCHAR(255) v5

contact INT UNSIGNED DEFAULT 0 v5

smsaccount MEDIUMINT UNSIGNED NOT NULL DEFAULT 0 v5

title VARCHAR(255) NOT NULL v5

campaign INT UNSIGNED NOT NULL DEFAULT 0 v5

locked BIT(1) NOT NULL DEFAULT 0 v5

isvm BIT(1) 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 smsque");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $phone = $resRow["phone"];  //
 $type = $resRow["type"];  //
 $message = $resRow["message"];  //
 $added = $resRow["added"];  //
 $image = $resRow["image"];  //
 $contact = $resRow["contact"];  //
 $smsaccount = $resRow["smsaccount"];  //
 $title = $resRow["title"];  //
 $campaign = $resRow["campaign"];  //
 $locked = $resRow["locked"];  //
 $isvm = $resRow["isvm"];  //
}

Other SMS/Voice Marketing Tables

smsaccountextensions smsaccountgroups smsaccounts smsar smsautoresponders smscredits smsfailures smsinbox smskeywords smslogs smsque

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us