// Query the database to get EVENTS which have atleast one upcoming
// SHOWING and order them by TotalSold tickets and ShowingStartDate
// Change trending_Showing.RushStatus = 0 to trending_Showing.Available > 0    by Leon 2014/09/23
$query = "SELECT * FROM trending_Event, trending_Showing\n\t\t\t\t\tWHERE trending_Event.EventID = trending_Showing.EventID\n\t\t\t\t\tAND trending_Event.trendingStatus = 1\n\t\t\t\t\tAND trending_Showing.Available > 0\n\t\t\t\t\tORDER BY trending_Event.TotalSold DESC, trending_Showing.ShowingStartDate";
$result = mysql_query($query, $con);
$phpResponseTrending = array();
// this variable updates the latest EVENT Name
$temp = "";
// this variable keeps a count on the number of EVENTS stored in array
// we need to limit this count to 5
$count = 0;
while ($count < 5 && ($row = mysql_fetch_assoc($result))) {
    $Name = $row['Name'];
    // convert $ShowingDateTime to array  by Leon 2014/09/23
    $ShowingStartDate = $row['ShowingStartDate'];
    $showingDateTime = dateTimeToArray($ShowingStartDate, 1);
    // If the EVENT is not already stored, save the required details
    // Event's $showingDateTime don't pass current Date.  by Leon 2014/09/23
    if (isLess($currDateTime, $showingDateTime) == -1 && $temp != $Name) {
        $count++;
        $temp = $Name;
        $TabletLink = $row['TabletLink'];
        $TotalSold = $row['TotalSold'];
        $ShowingVenueName = $row['ShowingVenueName'];
        $phpResponseTrending[] = array("Name" => $Name, "TabletLink" => $TabletLink, "TotalSold" => $TotalSold, "StartDate" => $ShowingStartDate, "VenueName" => $ShowingVenueName);
    }
}
// Print the data along with the generation of XMLFiles file, if needed
echo "<pre>";
print_r($phpResponseTrending);
echo "</pre>";
<?php

// --------------------------------------------------------------------- //
//  This script will send e-mail to required people with log file
//  as attachment, once everyday.
// --------------------------------------------------------------------- //
// Set the time-zone so the system takes in the correct current date and time
date_default_timezone_set('America/Los_Angeles');
$dateTime = date('Y-m-d H:i:s');
$currDateTime = dateTimeToArray($dateTime, 0);
// Set various email fields: to, from, subject, and so on
$filename = "logFiles/logFile" . $currDateTime[0] . $currDateTime[1] . $currDateTime[2] . ".txt";
$to = "*****@*****.**";
$from = "*****@*****.**";
$from_name = "Sharvari Kapadia";
$replyto = "*****@*****.**";
$subject = "Trending Films Log File for " . $currDateTime[1] . "/" . $currDateTime[2];
$message = "Please find the Trending films Log File for " . $currDateTime[1] . "/" . $currDateTime[2] . "." . "If you have any questions, please speak with Matt or Lou.";
// Updated contacts list
$to = "*****@*****.**";
$from = "*****@*****.**";
$from_name = "CQuest at Bravo";
$replyto = "*****@*****.**";
mail_attachment($filename, $to, $from, $from_name, $replyto, $subject, $message);
// --------------------------------------------------------------------- //
//  Function definition for mail_attachment()
// --------------------------------------------------------------------- //
function mail_attachment($filename, $to, $from, $from_name, $replyto, $subject, $message)
{
    $file = $filename;
    $file_size = filesize($file);
		</div> 
		<!-- header End -->
		
		<?php 
// Load XMLFiles in PHP variables
$xml = simplexml_load_file("XMLFiles/Trending_Top5Events.xml");
// Start a new list to print the EVENTS
echo "<ul>";
foreach ($xml->Show as $show) {
    // Save the SELECTED attributes for each EVENT, in PHP variables
    $Name = $show->Name;
    $TabletLink = $show->TabletLink;
    $StartDate = $show->StartDate;
    $VenueName = $show->VenueName;
    // Separate date and time
    $dateTime = dateTimeToArray($StartDate, 1);
    // Convert the date and time in MM/DD HH:MM (12-hour) format
    $month = $dateTime[1];
    $day = $dateTime[2];
    $hour = $dateTime[3];
    if ($hour < 12) {
        $ampm = "AM";
    } else {
        if ($hour > 12) {
            $ampm = "PM";
            $hour = $hour - 12;
        } else {
            if ($hour == 12) {
                $ampm = "PM";
            }
        }