<?php include "../includes/db.php"; include "../includes/functions.php"; $dateFrom = ""; // date $csv = '"Date'; $sqlDate = "SELECT * FROM fieldtripdates WHERE ID={$_POST['date']}"; $resultsDate = mysql_query($sqlDate); $row = mysql_fetch_array($resultsDate); if ($row['dateFrom'] == $row['dateTo']) { $csv .= '",' . dateMD($row['dateFrom']); } else { $csv .= '",' . dateMD($row['dateFrom']) . ' - ' . dateMD($row['dateTo']); } $dateFrom = $row['dateFrom']; $csv .= "\n\n"; // bus $csv .= "Bus\n"; // name and section $csv .= '#,Last Name,First Name,Section' . "\n"; // print last, first and section $sqlBusPeople = "SELECT \r\n\t\t\t\t\t\t\t\tfieldtrippeople.firstName, \r\n\t\t\t\t\t\t\t\tfieldtrippeople.lastName, \r\n\t\t\t\t\t\t\t\tfieldtriplabs.section \r\n\t\t\t\t\t\t\tFROM ((\r\n\t\t\t\t\t\t\t\tfieldtrippeople \r\n\t\t\t\t\t\t\t\t\tJOIN \r\n\t\t\t\t\t\t\t\tfieldtripdates \r\n\t\t\t\t\t\t\t\t\tON \r\n\t\t\t\t\t\t\t\t\t\tfieldtrippeople.datePreffered=fieldtripdates.ID) \r\n\t\t\t\t\t\t\t\t\t\t\tJOIN \r\n\t\t\t\t\t\t\t\t\t\tfieldtriptransportation \r\n\t\t\t\t\t\t\t\t\t\t\tON \r\n\t\t\t\t\t\t\t\t\t\t\t\tfieldtrippeople.transportation=fieldtriptransportation.ID)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tJOIN \r\n\t\t\t\t\t\t\t\t\t\t\t\tfieldtriplabs \r\n\t\t\t\t\t\t\t\t\t\t\t\t\tON \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tfieldtriplabs.ID=fieldtrippeople.section \r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE (fieldtripdates.ID={$_POST['date']} && fieldtriptransportation.ID='1' && fieldtrippeople.status='accepted') ORDER BY fieldtrippeople.lastName"; $resultsBusPeople = mysql_query($sqlBusPeople); $count = 1; while ($row = mysql_fetch_array($resultsBusPeople)) { $csv .= "{$count},{$row['lastName']},{$row['firstName']},{$row['section']}\n"; $count++; } // car $csv .= "Car\n";
$sqlCount = "SELECT * FROM fieldtrippeople JOIN fieldtripdates ON fieldtrippeople.datePreffered=fieldtripdates.ID WHERE fieldtripdates.dateFrom='{$row['dateFrom']}'"; $resultsCount = mysql_query($sqlCount); $count = 0; while ($rowCount = mysql_fetch_array($resultsCount)) { $count++; } if ($count < 46) { echo '<option'; if (!isset($success_message) && isset($_POST['datePreffered']) && $_POST['datePreffered'] == $row['ID']) { echo ' selected '; } echo ' value="' . $row['ID'] . '">'; if ($row['dateFrom'] == $row['dateTo']) { echo dateMD($row['dateFrom']); } else { echo dateMD($row['dateFrom']) . ' - ' . dateMD($row['dateTo']); } echo '</option>'; } } ?> </select> </td> <td valign="top" width="175" rowspan="9"> <table class="availability"> <?php $datesID = array(); $tempCount = 0; $sqlDatesArray = "SELECT * FROM fieldtripdates WHERE dateFrom>CURDATE() ORDER BY dateFrom";
?> </select> <select class="button white" name="fieldDates" onchange="this.form.submit();"> <?php $sql = "SELECT * FROM events WHERE (date_from={$_POST['years']} && type='fieldcamp' && status='approved') ORDER BY date_from DESC"; $results = mysql_query($sql) or die("Unable to execute:" . mysql_error()); while ($row = mysql_fetch_array($results)) { echo '<option '; echo 'value="' . dateInUS($row['date_from']) . '" '; if (isset($_POST['fieldDates']) && $_POST['fieldDates'] == dateInUS($row['date_from'])) { echo " selected"; } echo '>'; echo dateMD($row['date_from']) . ' - ' . dateMD($row['date_to']); echo '</option>'; if (isset($_POST['fieldDates']) && $_POST['fieldDates'] == dateInUS($row['date_from'])) { $ID = $row['ID']; } } ?> </select> <input class="button white" name="info" type="submit" value="INFO" /> <?php $sql_photos_button = "SELECT * FROM events WHERE ID={$ID}"; $results_photos_button = mysql_query($sql_photos_button) or die("Unable to execute:" . mysql_error()); $row_photos_button = mysql_fetch_array($results_photos_button);
echo $bCount; ?> " /> <input name="cCount" type="hidden" value="<?php echo $cCount; ?> " /> <tr height="30" > <td colspan="4"> <strong><span class="bottom_border"><?php if ($row['dateFrom'] == $row['dateTo']) { //echo dateInUS($row['dateFrom']); if ($row['dateFrom'] == '2013-10-05') { echo 'TBA'; } else { echo dateMD($row['dateFrom']); } } else { echo dateMONDD($row['dateFrom']) . ' - ' . dateMONDD($row['dateTo']); } ?> </span></strong> </td> </tr> <tr height="30"> <td width="25%"> Bus </td> <td width="25%"> <div class="<?php ///////