= '". date("Y")."-". date("m") ."-".date("d")."' AND `removed` != 'Y' ORDER BY `ctCMS_Events`.`StartDate`, `StartTime` ASC ";
$get_q = mysql_query($get_sql);
return $get_q;
}
function get_upcoming_events_limit($limit_num = 3){
$get_sql = "SELECT * FROM `ctCMS_Events` WHERE `StartDate` >= '". date("Y")."-". date("m") ."-".date("d")."' AND `removed` != 'Y' ORDER BY `ctCMS_Events`.`StartDate`, `StartTime` ASC LIMIT 0, $limit_num ";
$get_q = mysql_query($get_sql);
return $get_q;
}
function get_upcoming_events_filter($type, $department){
if($type != "all" && $department != "all"){
$get_sql = "SELECT * FROM `ctCMS_Events` WHERE `StartDate` >= '". date("Y")."-". date("m") ."-".date("d")."' AND `removed` != 'Y' and `Category` = '". $type. "' and `Department` LIKE '%". $department. "%' ORDER BY `ctCMS_Events`.`StartDate`, `StartTime` ASC ";
}
if($type != "all" && $department == "all"){
$get_sql = "SELECT * FROM `ctCMS_Events` WHERE `StartDate` >= '". date("Y")."-". date("m") ."-".date("d")."' AND `removed` != 'Y' and `Category` = '". $type. "' ORDER BY `ctCMS_Events`.`StartDate`, `StartTime` ASC ";
}
if($type == "all" && $department != "all"){
$get_sql = "SELECT * FROM `ctCMS_Events` WHERE `StartDate` >= '". date("Y")."-". date("m") ."-".date("d")."' AND `removed` != 'Y' and `Department` LIKE '%". $department. "%' ORDER BY `ctCMS_Events`.`StartDate`, `StartTime` ASC ";
}
//echo $get_sql;
if($type == "all" && $department == "all"){
return get_upcoming_events();
}
$get_q = mysql_query($get_sql) or die(mysql_error());
return $get_q;
}
function get_upcoming_events_bydept($department, $limit_num = 3){
$get_sql = "SELECT * FROM `ctCMS_Events` WHERE `StartDate` >= '". date("Y")."-". date("m") ."-".date("d")."' AND `removed` != 'Y' ";
if($department != ""){
$get_sql .= "and `Department` LIKE '%". $department. "%' ";
}
$get_sql .= " ORDER BY `ctCMS_Events`.`StartDate`, `StartTime` ASC LIMIT 0, $limit_num ";
$get_q = mysql_query($get_sql);
return $get_q;
}
?>
Buffalo Jugglers |