Table: designs

Tool: Design Management
Associated Objects: Designs, Design

Fields

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 designs");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $member = $resRow["member"];  //
 $title = $resRow["title"];  //
 $designtype = $resRow["designtype"];  //
 $description = $resRow["description"];  //
 $price = $resRow["price"];  //
 $paid = $resRow["paid"];  //
 $scriptapproved = $resRow["scriptapproved"];  //
 $designapproved = $resRow["designapproved"];  //
 $complete = $resRow["complete"];  //
 $photosapproved = $resRow["photosapproved"];  //
 $added = $resRow["added"];  //
 $updated = $resRow["updated"];  //
 $template = $resRow["template"];  //
 $site = $resRow["site"];  //
 $lastemployeeactiontime = $resRow["lastemployeeactiontime"];  //
 $lastclientactiontime = $resRow["lastclientactiontime"];  //
 $lastemployeeactionid = $resRow["lastemployeeactionid"];  //
 $lastemployeeaction = $resRow["lastemployeeaction"];  //
 $lastclientaction = $resRow["lastclientaction"];  //
 $statusupdated = $resRow["statusupdated"];  //
 $statuscolor = $resRow["statuscolor"];  //
 $draftupdated = $resRow["draftupdated"];  //
 $revisions = $resRow["revisions"];  //
 $locked = $resRow["locked"];  //
 $photos = $resRow["photos"];  //
 $designtemplate = $resRow["designtemplate"];  //
 $url = $resRow["url"];  //
}

Other Design Management Tables

designnotes     designphotos     designrevisions     designs     designtemplates     designtypes     setupdesign