Table: emailbroadcasts

Tool: Email Marketing

Fields

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 emailbroadcasts");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $subject = $resRow["subject"];  //
 $body = $resRow["body"];  //
 $member = $resRow["member"];  //
 $added = $resRow["added"];  //
 $query = $resRow["query"];  //
 $begintime = $resRow["begintime"];  //
 $ishtml = $resRow["ishtml"];  //
 $totalsize = $resRow["totalsize"];  //
 $locked = $resRow["locked"];  //
 $isbroadcast = $resRow["isbroadcast"];  //
 $ismember = $resRow["ismember"];  //
 $isadded = $resRow["isadded"];  //
 $iscomplete = $resRow["iscomplete"];  //
}

Other Email Marketing Tables

broadcastcontacts     doubleoptinsettings     emailautoresponders     emailbroadcasts     emaillinkclicks     emaillogs     emailque     emailtemplates     memberarassign     memberbroadcastlimits     signatures