questions Database Table

Table: questions

Tool: Question and Answer
Associated Objects: Questions, Question

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

question MEDIUMTEXT NOT NULL v5

added INT UNSIGNED NOT NULL v5

member INT UNSIGNED NOT NULL DEFAULT 0 v5

ispublic BIT(1) NOT NULL DEFAULT 0 v5

questioncategory TINYINT UNSIGNED NOT NULL DEFAULT 0 v5

body TEXT NOT NULL v5

updated INT UNSIGNED NOT NULL v5

visitor INT UNSIGNED NOT NULL 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 questions");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $question = $resRow["question"];  //
 $added = $resRow["added"];  //
 $member = $resRow["member"];  //
 $ispublic = $resRow["ispublic"];  //
 $questioncategory = $resRow["questioncategory"];  //
 $body = $resRow["body"];  //
 $updated = $resRow["updated"];  //
 $visitor = $resRow["visitor"];  //
}

Table: questions

Fields

Example PHP Usage

Other Question and Answer Tables