emailautoresponders Database Table

Table: emailautoresponders

Tool: Email Marketing
Associated Objects: AutoResponders, AutoResponder

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

subject VARCHAR(100) NOT NULL v5

body TEXT NOT NULL v5

day SMALLINT NOT NULL v5

member INT UNSIGNED NOT NULL v5

contactgroup INT UNSIGNED NOT NULL DEFAULT 1 v5

countdown BIT(1) NOT NULL DEFAULT 0 v5

textbody TEXT NOT NULL v5

allowdownlinecopy BIT(1) NOT NULL DEFAULT 0 v5

active BIT(1) NOT NULL DEFAULT 1 v5

calendar INT UNSIGNED NOT NULL DEFAULT 0 v5

membership SMALLINT UNSIGNED NOT NULL DEFAULT 0 v5

ishtml BOOL NOT NULL DEFAULT 0 v5

isadmin BIT(1) DEFAULT 0 v5

timeofday VARCHAR(5) NOT NULL v5.06

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 emailautoresponders");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $subject = $resRow["subject"];  //
 $body = $resRow["body"];  //
 $day = $resRow["day"];  //
 $member = $resRow["member"];  //
 $contactgroup = $resRow["contactgroup"];  //
 $countdown = $resRow["countdown"];  //
 $textbody = $resRow["textbody"];  //
 $allowdownlinecopy = $resRow["allowdownlinecopy"];  //
 $active = $resRow["active"];  //
 $calendar = $resRow["calendar"];  //
 $membership = $resRow["membership"];  //
 $ishtml = $resRow["ishtml"];  //
 $isadmin = $resRow["isadmin"];  //
 $timeofday = $resRow["timeofday"];  //
}

Other Email Marketing Tables

broadcastcontacts doubleoptinsettings emailautoresponders emailbroadcasts emaillinkclicks emaillogs emailque emailtemplates memberarassign memberbroadcastlimits signatures

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us