event Database Table

Table: event

Tool: Events
Associated Objects: Event, Events

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5

member INT UNSIGNED NOT NULL v5

description TEXT NOT NULL v5

eventtype SMALLINT UNSIGNED NOT NULL v5

place INT UNSIGNED NOT NULL DEFAULT 0 v5

title VARCHAR(255) NOT NULL v5

begin INT UNSIGNED NOT NULL v5

end 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 event");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $description = $resRow["description"];  //
 $eventtype = $resRow["eventtype"];  //
 $place = $resRow["place"];  //
 $title = $resRow["title"];  //
 $begin = $resRow["begin"];  //
 $end = $resRow["end"];  //
}

Other Events Tables

event eventdiscounts eventextras eventprices eventrecurremove eventrecurs eventsettings eventtickets eventtypes

Home | Partnership | Testimonials

Privacy/Terms | About Us | Contact Us