blogs Database Table

Table: blogs

Tool: Blog
Associated Objects: Blogs, Blog

Fields

id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT v5

member INT UNSIGNED NOT NULL v5

title VARCHAR(50) NOT NULL v5

blogtemplate SMALLINT UNSIGNED NOT NULL v5

commentson TINYINT NOT NULL DEFAULT 1 v5

contactgroup SMALLINT UNSIGNED NOT NULL v5

added INT UNSIGNED NOT NULL v5

adminblog 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 blogs");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $title = $resRow["title"];  //
 $blogtemplate = $resRow["blogtemplate"];  //
 $commentson = $resRow["commentson"];  //
 $contactgroup = $resRow["contactgroup"];  //
 $added = $resRow["added"];  //
 $adminblog = $resRow["adminblog"];  //
}

Other Blog Tables

blogcomments blogentries blogs blogtemplates blogvar blogvardata

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us