public function writeToDB()
{
CMSConnect();
$conferenceWriteSQL = "INSERT INTO tbl_conference_reservations VALUES (\n\t\t\t'{$this->callID}',\n\t\t\t'{$this->callDatetime}',\n\t\t\t'{$this->callDuration}',\n\t\t\t'{$this->chairName}',\n\t\t\t'{$this->notes}',\n\t\t\t'{$this->chairNumber}',\n\t\t\t'{$this->clientRef}',\n\t\t\t'{$this->company}',\n\t\t\t'{$this->confTitle}',\n\t\t\t'{$this->dialType}',\n\t\t\t'{$this->numDILines}',\n\t\t\t'{$this->numDOLines}',\n\t\t\t'{$this->resDate}',\n\t\t\t'{$this->schedulerTel}',\n\t\t\t'{$this->scheduler}',\n\t\t\t'{$this->takenBy}',\n\t\t\t'{$this->conferenceType}',\n\t\t\t'{$this->bridge}',\n\t\t\t'{$this->leadop}',\n\t\t\t'{$this->isCancelled}',\n\t\t\t'{$this->accountNumber}',\n\t\t\t'{$this->lastEdited}',\n\t\t\t'{$this->lastEditedBy}')\n\t\t\t";
//echo $conferenceWriteSQL;
$conferenceWriteResult = mysql_query($conferenceWriteSQL) or die("Query failed : " . mysql_error());
}
<HTML>
<HEAD>
<TITLE>Chorus Call South Africa - Call Management System</TITLE>
<meta http-equiv="refresh" content="60">
</HEAD>
<BODY>
<?php
require_once "cms_include.php";
CMSConnect();
$today = date("Ymd");
$today_display = date("F dS, Y");
$tomorrow = mktime(0, 0, 0, date("m"), date("d") + 1, date("Y"));
$tomorrow_display = date("F dS, Y", $tomorrow);
$tomorrow = date("Ymd", $tomorrow);
$yesterday = mktime(0, 0, 0, date("m"), date("d") - 1, date("Y"));
$yesterday_display = date("F dS, Y", $yesterday);
$yesterday = date("Ymd", $yesterday);
$day_after_tomorrow = mktime(0, 0, 0, date("m"), date("d") + 2, date("Y"));
$day_after_tomorrow_display = date("F dS, Y", $day_after_tomorrow);
$day_after_tomorrow = date("Ymd", $day_after_tomorrow);
$two_days_after_tomorrow = mktime(0, 0, 0, date("m"), date("d") + 3, date("Y"));
$two_days_after_tomorrow_display = date("F dS, Y", $two_days_after_tomorrow);
$two_days_after_tomorrow = date("Ymd", $two_days_after_tomorrow);
// First, Display Yesterdays calls for printing billings forms, or editing
echo "<table width='100%' border='1' cellspacing='0' cellpadding='1' bordercolor='white' rules=rows>\n";
echo "<tr><td colspan=11 bgcolor='#99cccc'><Font face ='Verdana' size=3><b><p align=center>Calls yesterday - {$yesterday_display} </b></td></tr>\n";
DisplayCallsOnDate($yesterday, $yesterday);
echo "</table>\n";
//Now, show todays calls for printing resforms and editing
echo "<table width='100%' border='1' cellspacing='0' cellpadding='1' bordercolor='white' rules=rows>\n";
