blogcomments Database Table

Table: blogcomments

Tool: Blog
Associated Objects: BlogComments, BlogComment

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

blogentry MEDIUMINT UNSIGNED NOT NULL v5

contact INT UNSIGNED NOT NULL v5

body TEXT NOT NULL v5

added INT UNSIGNED NOT NULL DEFAULT 0 v5

approved BIT(1) NOT NULL DEFAULT 0 v5

parent 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 blogcomments");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $blogentry = $resRow["blogentry"];  //
 $contact = $resRow["contact"];  //
 $body = $resRow["body"];  //
 $added = $resRow["added"];  //
 $approved = $resRow["approved"];  //
 $parent = $resRow["parent"];  //
}

Other Blog Tables

blogcomments blogentries blogs blogtemplates blogvar blogvardata

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us