0 ) // find the first date of the con {$mquery = "select Con from Cons where ConID = ".$con." " ; $mresults = mysql_query($mquery); $mrow = mysql_fetch_array($mresults); $convention = $mrow["Con"];} //if ($edate."" == "" ) // find the first date of the con // {$mquery = "select min(Edate) from Sessions where conid = ".$con." " ; // $mresults = mysql_query($mquery); // $mrow = mysql_fetch_array($mresults); // $edate = $mrow[0];} $sort = "sort"; if ($sort == "") { $sort = "session";} if (isset($_REQUEST['descr'])) { $descr = $_REQUEST['descr']; } else { $descr = NULL; } $qtail = ""; // ================= Construct SQL if ($etypeid."" > "") { $qtail = $qtail." and EtypeID = ".$etypeid; } if ($gameid."" > "") { $qtail = $qtail." and GameID = ".$gameid ; } if ($con > "") { $qtail = $qtail." and conID = ".$con ; } if ($edate > "") { $qtail = $qtail." and Edate = '".$edate."'"; } if ($descr > "") { $qtail = $qtail." and (Descr like '%".$descr."%' or Session like '%".$descr."%')"; } //$qtail = " and Edate = '2016-07-15' "; //echo $qtail; // ========================================= ?> Schedule


".jddayofweek(date('w', strtotime($curdate))-1,2)." - ".$curdate."


"; ?> ".substr($list[$rcnt],0,5).""; $rcnt = $rcnt + 1; } $maxcnt = $rcnt - 1; ?> $lastsess) { //================finish out the last row if necessary while ( $rcnt <= $maxcnt ) { echo ""; $rcnt = $rcnt + 1 ; } //============================= echo ""; echo ""; // Title // reset the slot counter $rcnt = 1 ; } /// ========= Resolve multiple use for dur - until I change it in DB $colspan = intval($row["Dur"]); // ================== Fill the gap til the next session (or the end of the row = while ( ($list[$rcnt] < $row["Etime"]) and ($rcnt <= $maxcnt )) { echo ""; $rcnt = $rcnt + 1 ; } // ============= display the session echo " "; $rcnt = $rcnt + $colspan; $lastsess = $row["Session"]; // ========================= } ?>   "; $rcnt = $rcnt + 1 ; } // ===================================== ?>
Title  
".$row["Session"]."   "; echo "".$row["Filled"]."/".$row["Players"].""; echo "