= %s and end_datetime is null order by date_time desc",GetSQLValueString($min_session_datetime,"date"));
// NOTE: The check for 'ticket.type is null' is filtering the results to only return sessions
// where the session ID is not stored in the ticket table (i.e. the join on the ticket table for
// session.session_id = ticket.session_id is empty).
// The purpose of this filtering is unclear, but appears to be in place to only return master tickets.
$get_sessions = mysql_query($sql_get_sessions) or die(mysql_error());
printf("Active Ensemble QPI Sessions
");
printf("| Last Name | First Name | Middle Name | Subject ID | Session ID | Date/Time | Experiment title |
|---|
\n");
while($row_get_sessions = mysql_fetch_assoc($get_sessions)) {
printf("");
printf("| %s | %s | %s | %s | %d | %s | %s |
\n",$row_get_sessions['name_last'],$row_get_sessions['name_first'],
$row_get_sessions['name_middle'],$row_get_sessions['subject_id'],
$row_get_sessions['session_id'],$row_get_sessions['date_time'],$row_get_sessions['experiment_title']);
}
printf("
");
?>