Arts & Culture
Career Skills
Community Service
Film Series
Intellectual Programs
Mentoring
Recreation & Outings
T.A./Ph.D Support
General Programs
New Student Orientation
Other Events
|
Penn | FAQ | Feedback | Grad Center Listserv | Calendar | Resource Guide |
Events
| Facilities |
Services |
$strQueryt = "SELECT PROGRAM_AREA_ID, PROGRAM_DESC, PROGRAM_AREA FROM TBL_PROGRAM_AREA WHERE PROGRAM_AREA_ID=1";
$RST = $connt->Execute($strQueryt);
?>
= $RST->Fields["PROGRAM_AREA"]->value ?>
= $RST->Fields["PROGRAM_DESC"]->value ?>
closeRS($RST);
closeConn($connt);
?>
$strQuery0 = "SELECT E.EVENT_ID,E.EVENT_NAME as NAME,E.EVENT_DESC as DESCRIPTION,E.ITINERARY as ITI,E.EVENT_ACTIVE,E.SERIES_ID,S.SESSION_DATE as DATE1,S.SESSION_LOCATION as LOCATION,S.SESSION_START as START,S.SESSION_END as END, S.SHOW1 as SHOW, E.HAS_SIGNUP as SIGNUP FROM TBL_EVENT E, TBL_SESSION S WHERE E.EVENT_ID=S.EVENT_ID and E.EVENT_ACTIVE=1 and E.PROGRAM_AREA_ID=1 and E.SERIES_ID= 0 order by E.SERIES_ID,7";
$RS0 = $conn0->Execute($strQuery0);
while (!$RS0->EOF){
$showdate1="";
$showdate1 .= $RS0->Fields["SHOW"]->value ;
$signup.= $RS0->Fields["SIGNUP"]->value;
?>
= $RS0->Fields["NAME"]->value ?>
if ($showdate1 == ""){
?>
= displayLongDate($RS0->Fields["DATE1"]->value) ?>, = $RS0->Fields["START"]->value ?> - = $RS0->Fields["END"]->value ?>
= $RS0->Fields["LOCATION"]->value ?>
}
?>
if ($showdate1 == "DTL" and $showdate1 != "" ){
?>
= displayLongDate($RS0->Fields["DATE1"]->value) ?>, = $RS0->Fields["START"]->value ?> - = $RS0->Fields["END"]->value ?>
= $RS0->Fields["LOCATION"]->value ?>
}
?>
if ($showdate1 == "DT" and $showdate1 != "" ){
?>
= displayLongDate($RS0->Fields["DATE1"]->value) ?>, = $RS0->Fields["START"]->value ?> - = $RS0->Fields["END"]->value ?>
}
?>
if ($showdate1 == "DL" and $showdate1 != "" ){
?>
= displayLongDate($RS0->Fields["DATE1"]->value) ?>
= $RS0->Fields["LOCATION"]->value ?>
}
?>
if ($showdate1 == "TL" and $showdate1 != "" ){
?>
= $RS0->Fields["START"]->value ?> - = $RS0->Fields["END"]->value ?>
= $RS0->Fields["LOCATION"]->value ?>
}
?>
if ($showdate1 == "L" and $showdate1 != "" ){
?>
= $RS0->Fields["LOCATION"]->value ?>
}
?>
if ($showdate1 == "D" and $showdate1 != "" ){
?>
= displayLongDate($RS0->Fields["DATE1"]->value) ?>
}
?>
= $RS0->Fields["DESCRIPTION"]->value?>
= $RS0->Fields["ITI"]->value?>
$RS0->MoveNext();
}
?>
closeRS($RS0);
closeConn($conn0);
?>
$strQuerys = "SELECT SERIES_ID,SERIES_NAME,SERIES_DESC FROM TBL_SERIES WHERE PROGRAM_AREA_ID=1 and ACTIVE=1 order by SERIES_ID ";
$RSS = $conns->Execute($strQuerys);
$seriesid=0;
while (!$RSS->EOF){
$seriesid .= $RSS->Fields["SERIES_ID"]->value ;
?>
$strQuery = "SELECT E.EVENT_ID,E.EVENT_NAME as NAME,E.EVENT_DESC as DESCRIPTION,E.ITINERARY as ITI,E.EVENT_ACTIVE,E.SERIES_ID,S.SESSION_DATE as DATE1,S.SESSION_LOCATION as LOCATION,S.SESSION_START as START,S.SESSION_END as END, S.SHOW1 as SHOW, E.HAS_SIGNUP as SIGNUP FROM TBL_EVENT E, TBL_SESSION S WHERE E.EVENT_ID=S.EVENT_ID and E.EVENT_ACTIVE=1 and E.PROGRAM_AREA_ID=1 and E.SERIES_ID= $seriesid order by E.SERIES_ID,7";
$RS = $conn->Execute($strQuery);
if ($seriesid!=0)
{
?>
= $RSS->Fields["SERIES_NAME"]->value ?>
= $RSS->Fields["SERIES_DESC"]->value ?>
}
?>
while (!$RS->EOF){
$showdate1="";
$showdate1 .= $RS->Fields["SHOW"]->value ;
$signup .= $RS0->Fields["SIGNUP"]->value;
?>
= $RS->Fields["NAME"]->value ?>
if ($showdate1 == ""){
?>
= displayLongDate($RS->Fields["DATE1"]->value) ?>, = $RS->Fields["START"]->value ?> - = $RS->Fields["END"]->value ?>
= $RS->Fields["LOCATION"]->value ?>
}
?>
if ($showdate1 == "DTL" and $showdate1 != "" ){
?>
= displayLongDate($RS->Fields["DATE1"]->value) ?>, = $RS->Fields["START"]->value ?> - = $RS->Fields["END"]->value ?>
= $RS->Fields["LOCATION"]->value ?>
}
?>
if ($showdate1 == "DT" and $showdate1 != "" ){
?>
= displayLongDate($RS->Fields["DATE1"]->value) ?>, = $RS->Fields["START"]->value ?> - = $RS->Fields["END"]->value ?>
}
?>
if ($showdate1 == "D" and $showdate1 != "" ){
?>
= displayLongDate($RS->Fields["DATE1"]->value) ?>
}
?>
if ($showdate1 == "DL" and $showdate1 != "" ){
?>
= displayLongDate($RS->Fields["DATE1"]->value) ?>
= $RS->Fields["LOCATION"]->value ?>
}
?>
if ($showdate1 == "TL" and $showdate1 != "" ){
?>
= $RS->Fields["START"]->value ?> - = $RS->Fields["END"]->value ?>
= $RS->Fields["LOCATION"]->value ?>
}
?>
if ($showdate1 == "L" and $showdate1 != "" ){
?>
= $RS->Fields["LOCATION"]->value ?>
}
?>
= $RS->Fields["DESCRIPTION"]->value?>
= $RS->Fields["ITI"]->value?>
if ($signup!="")
{
?>
Register
here
}
?>
$RS->MoveNext();
}
?>
$RSS->MoveNext();
$seriesid=0;
}
?>
closeRS($RS);
closeConn($conn);
?>
closeRS($RSS);
closeConn($conns);
?>
|