forumthreads Database Table

Table: forumthreads

Tool: Forum
Associated Objects: ForumThreads, ForumThread

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

forum INT UNSIGNED NOT NULL v5

title VARCHAR(50) NOT NULL v5

ownertype TINYINT UNSIGNED NOT NULL v5

owner INT UNSIGNED NOT NULL v5

locked BIT(1) NOT NULL DEFAULT 0 v5

added INT UNSIGNED v5

updated INT UNSIGNED NOT NULL v5

directory VARCHAR(100) NOT NULL v5

views INT 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 forumthreads");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $forum = $resRow["forum"];  //
 $title = $resRow["title"];  //
 $ownertype = $resRow["ownertype"];  //
 $owner = $resRow["owner"];  //
 $locked = $resRow["locked"];  //
 $added = $resRow["added"];  //
 $updated = $resRow["updated"];  //
 $directory = $resRow["directory"];  //
 $views = $resRow["views"];  //
}

Other Forum Tables

forumauth forumpostlikes forumposts forums forumthreads

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us