";
$i = 1;
while($row = mysqli_fetch_array($result)){
if(($displayby == "category_BC") && ($i<=1)){
$price = "\n
';
?>
0");
// $postnum = mysql_result($getcount,0);
mysqli_data_seek($getcount,0);
$f = mysqli_fetch_array( $getcount );
$postnum = $f[0];
$limit = 10;
if($postnum > $limit){
$tagend = round($postnum % $limit,0);
$splits = round(($postnum - $tagend)/$limit,0);
if($tagend == 0){
$num_pages = $splits;
}
else{
$num_pages = $splits + 1;
}
if(isset($_GET['pg'])){
$pg = $_GET['pg'];
}else{
$pg = 1;
}
$startpos = ($pg*$limit)-$limit;
$limstring = "LIMIT $startpos,$limit";
}else{
$limstring = "LIMIT 0,$limit";
}
}
//////////////
/////////////////////////Filtering Generes////////////////////////////////////////
$result = mysqli_query($connect,"SELECT * FROM courses WHERE credit_BC > 0 ORDER by seminar ASC $limstring");
$displayby = $_GET['displayby'];
$displayvalue = $_GET['displayvalue'];
if(isset($displayby) &&isset($displayvalue)){
$result = mysqli_query($connect,"SELECT * FROM courses WHERE
$displayby LIKE '$displayvalue' AND credit_BC > 0");
}
////////////////////////////Displaying on page////////////////////////////////////////
while($row = mysqli_fetch_array($result)){
echo "" .$row['category_BC']. ' Courses '. "
"; echo $price; $i++; } }// end loop if($displayby == ""){ $price = "\n" .' All Courses '. "
"; echo $price; } echo '";
$seminar =$row['seminar'];
$title = "\n";
echo $title;
echo "
";/*coursebox*/
}// end loop
echo "\n";
/*Date*/
/*echo "
";/*leftbox*/
/*Description*/
echo "";
echo "
";/*datebox*/
/*Class*/
echo "".'Date:'."
";
$x = $row['month'];
switch($x){
case "1":
echo "\n".'January'. ' ' . $row['day'] .', ' .
$row['year']."
";
break; // January
case "2":
echo "\n".'February'. ' ' . $row['day'] .', ' .
$row['year']."
";
break; // February
case "3":
echo "\n".'March'. ' ' . $row['day'] .', ' .
$row['year']."
";
break; // March
case "4":
echo "\n".'April'. ' ' . $row['day'] .', ' .
$row['year']."
";
break; // April
case "5":
echo "\n".'May'. ' ' . $row['day'] .', ' .
$row['year']."
";
break; // May
case "6":
echo "\n".'June'. ' ' . $row['day'] .', ' .
$row['year']."
";
break; // June
case "7":
echo "\n".'July'. ' ' . $row['day'] .', ' .
$row['year']."
";
break; // July
case "8":
echo "\n".'August'. ' ' . $row['day'] .', ' .
$row['year']."
";
break; // August
case "9":
echo "\n".'September'. ' ' . $row['day'] .', ' .
$row['year']."
";
break; // September
case "10":
echo "\n".'October'. ' ' . $row['day'] .', ' .
$row['year']."
";
break; // October
case "11":
echo "\n".'November'. ' ' . $row['day'] .', ' .
$row['year']."
";
break; // November
case "12":
echo "\n".'December'. ' ' . $row['day'] .', ' .
$row['year']."
";
break; // December
}
$time = "\n" .$row['time']. "
";
echo $time;*/
/*echo "";
echo "
"; $category = "
";/*classbox*/
echo "".'Category:'."
"; $category = "
" .$row['category_BC']. "
";
echo $category;
echo "";
echo "
"; $class = "\n
";/*classbox*/
/*Credit*/
echo "".'Class:'."
"; $class = "\n
" .$row['class']. "
";
echo $class;
echo "";
echo "
";/*creditbox*/
/*Register*/
/*echo "".'Credits:'."
";
$credit = "\n" .$row['credit_BC']. "
";
echo $credit;
echo "".'Register'."
";*/
echo "";
$desc = "\n
";/*descbox*/
echo "" .$row['description']. "
";
echo $desc;
echo "";
///////////////// pagination links
if($postnum > $limit){
echo "Pages: ";
$n = $pg + 1;
$p = $pg - 1;
$thisroot = $_SERVER['PHP_SELF'];
if($pg > 1){
echo "prev ";
}
for($i=1; $i<=$num_pages; $i++){
if($i!= $pg){
echo "$i ";
}else{
echo "$i ";
}
}
if($pg < $num_pages){
echo "next";
}
echo " ";
}
////////////// end pagination
?>