$html .= "<div class='passengers block'>"; while ($passenger = mysql_fetch_array($carpoolDetails)) { //$passengers[] = $passenger['memberID']; if ($passenger['memberID'] !== $driver) { //$shouldAttend=''; //$isConfirmed =''; //$passengerSpots=0; $emails .= ', ' . prefFullNameFromEmail($passenger['memberID']) . ' <' . $passenger['memberID'] . '>'; if (shouldAttend($passenger['memberID'], $eventNo)) { $shouldAttend = '<span class="label label-info">should</span>'; $isConfirmed = isConfirmed($passenger['memberID'], $eventNo) == true ? '<span class="label label-info">confirmed</span>' : '<span class="label label-warning">unconfirmed</span>'; } else { $shouldAttend = '<span class="label label-important">shouldn\'t</span>'; $isConfirmed = '<span class="label label-important">not attending</span>'; } $passengerSpots = passengerSpots($passenger['memberID']) !== "0" ? "<span class='badge badge-info'>" . passengerSpots($passenger['memberID']) . "</span>" : ''; $livesAt = "<span class='label'>" . livesAt($passenger['memberID']) . "</span>"; $phoneNumber = "<a href='tel:" . phoneNumber($passenger['memberID']) . "'>" . phoneNumber($passenger['memberID']) . "</a>"; $html .= "<div class='person' id='" . $passenger['memberID'] . "'><table>\n\t\t\t<tr>\n\t\t\t\t<td class='carpoolLives'>" . $livesAt . "</td>\n\t\t\t\t<td class='carpoolName'><a href='profile:" . $passenger['memberID'] . "'>" . prefFullNameFromEmail($passenger['memberID']) . "</a></td>\n\t\t\t\t<td class='carpoolSpots'>" . $passengerSpots . "</td>\n\t\t\t\t<td class='carpoolShould'>" . $phoneNumber . "</td>\n\t\t\t\t<td class='carpoolConfirmed'>" . $isConfirmed . "</td>\n\t\t\t\t</tr>\n\t\t\t</table></div>"; } } $sql = "select `name` from `event` where `eventNo` = {$eventNo}"; $event = mysql_fetch_array(mysql_query($sql)); $html .= '</div>'; //end passengers div $html .= '<div style="display: inline-block; width: 100%"><a href="mailto:' . rawurlencode($emails) . '?subject=' . rawurlencode('Carpool for ' . $event['name']) . '" class="btn pull-right"><i class="icon-envelope"></i> Mail this carpool</a></div>'; $html .= "</div>"; //end carpool div } $html .= "</div>"; echo $html;
<?php require_once 'functions.php'; $eventNo = $_POST['eventNo']; $needRides = array(); $sql = "\n\tSELECT email,shouldAttend,attends.confirmed \n\tFROM member,attends\n\tWHERE\n\t\temail NOT IN (\n\t\t\tSELECT email FROM carpool, ridesin LEFT JOIN member \n\t\t\t\tON email=memberID \n\t\t\tWHERE carpool.carpoolID=ridesin.carpoolID AND carpool.eventNo={$eventNo})\n\t\tAND exists (select * from `activeSemester` where `activeSemester`.`semester` = '{$SEMESTER}' and `activeSemester`.`member` = `member`.`email`)\n\t\tAND attends.eventNo={$eventNo}\n\t\tAND attends.memberID=email\n\tORDER BY shouldAttend DESC, lastName ASC, firstName ASC"; $results = mysql_query($sql); while ($personInNeedOfRide = mysql_fetch_array($results)) { $email = $personInNeedOfRide['email']; $shouldAttend = $personInNeedOfRide['shouldAttend']; $confirmed = $personInNeedOfRide['confirmed']; $shouldAttendHTML = $shouldAttend == '1' ? '<span class="label label-info">should</span>' : '<span class="label label-important">shouldn\'t</span>'; $confirmedHTML = $confirmed == '1' ? '<span class="label label-info">confirmed</span>' : '<span class="label label-warning">unconfirmed</span>'; $passengerSpots = passengerSpots($email) !== "0" ? "<span class='badge badge-info'>" . passengerSpots($email) . "</span>" : ""; $livesAt = "<span class='label'>" . livesAt($email) . "</span>"; echo "<div class='person' id='" . $email . "'><table>\n\t\t<tr>\n\t\t\t<td>{$livesAt}</td>\n\t\t\t<td>" . prefFullNameFromEmail($email) . "</td>\n\t\t\t<td class='passengerSpots'>{$passengerSpots}</td>\n\t\t\t<td>{$shouldAttendHTML}</td>\n\t\t\t<td>{$confirmedHTML}</td>\n\t\t</tr>\n\t</table></div>"; }