Location: PHPKode > projects > Clinical Handover Database > output/include/Current_Jobs_variables.php
<?php

$strTableName="Current Jobs";

$strOriginalTableName="jobs";
$gPageSize=100;

$gstrOrderBy="ORDER BY `Patient Name` ASC";
if(strlen($gstrOrderBy) && strcasecmp(substr($gstrOrderBy,0,8),"order by"))
	$gstrOrderBy="order by ".$gstrOrderBy;
	
$gstrSQL = "select `Primary`,   `Patient Name`,   `Date`,   `Type`,   `Status`,   `Name`,   `Result`,   `Notes`,   `Consultant`   From `jobs`  WHERE NOT `Status` = \"Completed\"";

//	thumbnails

$thumbnail_fields = array();
//	$thumbnail_fields = array("Field1","Field2");
//	field names are case-sensitive!
$thumbnail_prefixes = array();
//	$thumbnail_prefixes = array("Field1"=>"t1_" , "Field2"=>"t2_");
$thumbnail_maxsize = 150;

$ColumnsCount		= 1;

include("include/Current_Jobs_events.php");
?>
Return current item: Clinical Handover Database