scheduledcontents Database Table

Table: scheduledcontents

Tool: Scheduled Content
Associated Objects: ScheduledContents, ScheduledContent

Fields

id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT v5

title VARCHAR(100) NOT NULL v5

description TEXT NOT NULL v5

fieldtype TINYINT NOT NULL DEFAULT 1 v5

dorder TINYINT UNSIGNED NOT NULL v5

member INT UNSIGNED NOT NULL DEFAULT 0 v5

membership SMALLINT UNSIGNED 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 scheduledcontents");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $title = $resRow["title"];  //
 $description = $resRow["description"];  //
 $fieldtype = $resRow["fieldtype"];  //
 $dorder = $resRow["dorder"];  //
 $member = $resRow["member"];  //
 $membership = $resRow["membership"];  //
}

Table: scheduledcontents

Fields

Example PHP Usage

Other Scheduled Content Tables