='2'){ mysql_connect("$DBHost","$DBUser","$DBPass"); $result1 = mysql("$DBName","select * from Instructors WHERE InstructorID LIKE '$InstID%'"); while ($row1 = mysql_fetch_row($result1)) { $Instructor=$row1[2]; $plain=explode(",",$Instructor); $plainInstructor=$plain[1].' '.$plain[0]; } } else { $InstID='1'; $plainInstructor='Steve Veltkamp'; } $pageTitle="Seminars by $plainInstructor"; $description='Business success is easier with what you learn at a BizShop entrepreneur seminar'; include("masthead.php"); echo "[ Calendar View ]
"; echo "Click on any class title to read description, any location to register"; //$RowColor=SwapRowColor(); echo ""; // ========================= Setup # to display on page if (empty($offset) || $offset < 0) { $offset=0; } // ================== Get Count For Table =============== $sql="select * from Schedule WHERE InstructorID='".$InstID."' AND DTG>'".$nowDTG."' Order by DTG"; $stmt = $dbCal->query($sql); $rows = $stmt->rowCount(); //echo $rows.' rows selected'; //print_r($result); $begin =($offset+1); $end = ($begin+($limit-1)); if ($end > $rows) { $end = $rows; } if ($rows==0){ echo ""; } elseif ($rows==1){ echo ""; } else { echo ""; } echo ''; // ===================Headings================= if ($rows!='0'){ echo ""; } // exit(); // ===================== Get Data ============= while($row = $stmt->fetch(PDO::FETCH_ASSOC)){ //echo $row['DTG'].' '.$row['End_DTG']; $InDTG=$row['DTG']; //echo '

---

Start '.$InDTG.'_ '; include("datefunction.php"); // echo ' dmktime'.$DMKTIME; $startDate=date("D j M Y",$DMKTIME); // echo $startDate.'

---

'; $startTime=date("g:ia","$DMKTIME"); $EndDTG=$row['End_DTG']; $InDTG=$EndDTG; include("datefunction.php"); $endDate=date("D j M Y","$DMKTIME"); $endTime=date("g:ia","$DMKTIME"); $Instructor=$row['Instructor']; $CourseID=$row['CourseID']; $Information=$row['Information']; $SchoolID=$row['SchoolID']; $SchoolCourseID=$row['SchoolCourseID']; //echo $SchoolCourseID; $schoolsql = "select * from Schools WHERE SchoolID='$SchoolID'"; //echo $schoolsql.'

---

'; $schoolstmt = $dbCal->query($schoolsql); while ($schoolresults = $schoolstmt->fetch(PDO::FETCH_NUM)) { //print_r($schoolresults); //echo $schoolresults[6]; $School=$schoolresults[1]; $City=$schoolresults[6]; $State=$schoolresults[7]; //echo $School.' '.$City.','.$State.'

---

'; } $EventID=$row[6]; if($CourseID){ $coursesql = "select * from Courses WHERE CourseID='$CourseID'"; //echo $coursesql.'

---

'; $Coursestmt = $dbCal->query($coursesql); while ($courserow = $Coursestmt->fetch(PDO::FETCH_NUM)) { $Event=$courserow[1]; // $Info=$result['Information']; //echo $Event; } } $queryvar="&table=calendar&?menuid=6&ID=$ID"; //$RowColor=SwapRowColor(); echo ""; $i++; } echo ''; echo '

There are none found
There is only $rows found.
There are $rows found,"; echo " now showing $begin to $end.
Date & Time	Seminar	Location<
$startDate $startTime-$endTime	$Event"; if($CourseID=='99' AND $Information!=''){ echo "- $Information"; } echo "	$City, $State

'; // =============================================== Next/Previous echo "

"; include('nextprevious.php'); echo "

"; include("footer.php"); ?>