<.html include("connection.html") ?> GovEnergy 2009 Program-At-A-Glance <.html mysql_select_db($dbname, $con); $result = mysql_query("SELECT trackname,id FROM roads ORDER BY trackname"); ?> <.html $segstart = ''; $segend = ''; $sess = ''; ?>

GovEnergy 2009 Program-At-A-Glance

Back to GovEnergy site

<.html while($row = mysql_fetch_array($result)) { $i=1; $ttrack = $row['id']; $result2 = mysql_query("SELECT items.id, items.sessionname, items.sessiondesc, segments.starttime, segments.endtime, items_roads.item_id, items_roads.road_id FROM items JOIN items_roads ON (items_roads.road_id=".$ttrack." AND items_roads.item_id = items.id) JOIN segments ON (items.segment_id = segments.id )"); if($i == 1) { echo '"; } } ?>

 

August 10, 2009
EXHIBIT HALL OPENS
8:00 AM
OPENING BREAKFAST HALL C&D
7:30 AM - 8:30 AM
OPENING PLENARY SESSION
8:00 AM - 9:00 AM
SESSION 1
<.html $sess = "\"Session 1\""; $resultseg = mysql_query("SELECT segmentname, starttime, endtime from segments WHERE segmentname = ".$sess.""); while($rowseg = mysql_fetch_array($resultseg)) { $segstart = date("g:i a", strtotime($rowseg['starttime'])); $segend = date("g:i a", strtotime($rowseg['endtime'])); echo $segstart.' - '.$segend; break; } ?>
NETWORKING LUNCH HALL C&D
12:00 PM - 2:00 PM
SESSION 2
<.html $sess = "\"Session 2\""; $resultseg2 = mysql_query("SELECT segmentname, starttime, endtime from segments WHERE segmentname = ".$sess.""); while($rowseg2 = mysql_fetch_array($resultseg2)) { $segstart = date("g:i a", strtotime($rowseg2['starttime'])); $segend = date("g:i a", strtotime($rowseg2['endtime'])); echo $segstart.' - '.$segend; break; } ?>
NETWORKING BREAK EXHIBIT HALL
3:30 PM - 4:00 PM
SESSION 3
<.html $sess = "\"Session 3\""; $resultseg3 = mysql_query("SELECT segmentname, starttime, endtime from segments WHERE segmentname = ".$sess.""); while($rowseg3 = mysql_fetch_array($resultseg3)) { $segstart = date("g:i a", strtotime($rowseg3['starttime'])); $segend = date("g:i a", strtotime($rowseg3['endtime'])); echo $segstart.' - '.$segend; break; } ?>
NETWORKING EVENT HALL A&B
5:00 PM - 6:30 PM
August 11, 2009
NETWORKING BREAKFAST HALL C&D
7:30 AM - 8:30 AM
SESSION 4
<.html $sess = "\"Session 4\""; $resultseg4 = mysql_query("SELECT segmentname, starttime, endtime from segments WHERE segmentname = ".$sess.""); while($rowseg4 = mysql_fetch_array($resultseg4)) { $segstart = date("g:i a", strtotime($rowseg4['starttime'])); $segend = date("g:i a", strtotime($rowseg4['endtime'])); echo $segstart.' - '.$segend; break; } ?>
NETWORKING BREAK EXHIBIT HALL
10:00 AM - 10:30 AM
SESSION 5
<.html $sess = "\"Session 5\""; $resultseg5 = mysql_query("SELECT segmentname, starttime, endtime from segments WHERE segmentname = ".$sess.""); while($rowseg5 = mysql_fetch_array($resultseg5)) { $segstart = date("g:i a", strtotime($rowseg5['starttime'])); $segend = date("g:i a", strtotime($rowseg5['endtime'])); echo $segstart.' - '.$segend; break; } ?>
NETWORKING LUNCH HALL C&D
12:00 PM - 2:00 PM
SESSION 6
<.html $sess = "\"Session 6\""; $resultseg6 = mysql_query("SELECT segmentname, starttime, endtime from segments WHERE segmentname = ".$sess.""); while($rowseg6 = mysql_fetch_array($resultseg6)) { $segstart = date("g:i a", strtotime($rowseg6['starttime'])); $segend = date("g:i a", strtotime($rowseg6['endtime'])); echo $segstart.' - '.$segend; break; } ?>
NETWORKING BREAK
3:30 PM - 4:00 PM
EXHIBIT HALL CLOSES
4:00 PM
SESSION 7
<.html $sess = "\"Session 7\""; $resultseg7 = mysql_query("SELECT segmentname, starttime, endtime from segments WHERE segmentname = ".$sess.""); while($rowseg7 = mysql_fetch_array($resultseg7)) { $segstart = date("g:i a", strtotime($rowseg7['starttime'])); $segend = date("g:i a", strtotime($rowseg7['endtime'])); echo $segstart.' - '.$segend; break; } ?>
OFF-SITE NETWORKING EVENT
6:00 PM - 8:30 PM
August 12, 2009
NETWORKING BREAKFAST HALL C&D
7:30 AM - 8:30 AM
SESSION 8
<.html $sess = "\"Session 8\""; $resultseg8 = mysql_query("SELECT segmentname, starttime, endtime from segments WHERE segmentname = ".$sess.""); while($rowseg8 = mysql_fetch_array($resultseg8)) { $segstart = date("g:i a", strtotime($rowseg8['starttime'])); $segend = date("g:i a", strtotime($rowseg8['endtime'])); echo $segstart.' - '.$segend; break; } ?>
NETWORKING BREAK EXHIBIT HALL
10:00 AM - 10:30 AM
SESSION 9
<.html $sess = "\"Session 9\""; $resultseg9 = mysql_query("SELECT segmentname, starttime, endtime from segments WHERE segmentname = ".$sess.""); while($rowseg9 = mysql_fetch_array($resultseg9)) { $segstart = date("g:i a", strtotime($rowseg9['starttime'])); $segend = date("g:i a", strtotime($rowseg9['endtime'])); echo $segstart.' - '.$segend; break; } ?>
CLOSING LUNCHEON PLENARY HALL C&D
12:00 PM - 2:00 PM
Seated/plated lunch
AGENCY BREAKOUT MEETINGS HALL C&D, BALLROOMS A-E, MEETING ROOMS 550-558 & ROTUNDA

 

'; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo '"; echo ""; echo ""; echo '"; echo ""; echo ''; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

'.$row['trackname'].'

August 10, 2009
'; //echo 'OPENING BREAKFAST HALL C&D
7:30 AM - 8:30 AM'; echo '

 

'; echo '
'; //echo 'EXHIBIT HALL OPENS
8:00 AM'; echo '

 

'; echo '
'; //echo 'OPENING PLENARY SESSION
8:00 AM - 9:00 AM'; echo '

 

'; echo '
'; } while($row2 = mysql_fetch_array($result2)) { $starttime = $row2['starttime']; $tstartime = date("Y-m-d g:i a", strtotime($starttime)); #echo $tstartime; if ($tstartime == "2009-08-10 10:30 am") { echo ''.$row2['sessionname'].''; break; } } echo ' '; if($i == 1) { echo "
'; //echo "NETWORKING LUNCH HALL C&D
12:00 PM - 2:00 PM"; echo '

 

'; echo "
"; } $result3 = mysql_query("SELECT items.id, items.sessionname, items.sessiondesc, segments.starttime, segments.endtime, items_roads.item_id, items_roads.road_id FROM items JOIN items_roads ON (items_roads.road_id=".$ttrack." AND items_roads.item_id = items.id) JOIN segments ON (items.segment_id = segments.id )"); while($row3 = mysql_fetch_array($result3)) { $starttime = $row3['starttime']; $tstartime = date("Y-m-d g:i a", strtotime($starttime)); #echo $tstartime; if ($tstartime == "2009-08-10 2:00 pm") { echo ''.$row3['sessionname'].''; break; } } echo ' '; if($i == 1) { echo "
"; //echo "NETWORKING BREAK EXHIBIT HALL
3:30 PM - 4:00 PM"; echo '

 

'; echo "
"; } $result4 = mysql_query("SELECT items.id, items.sessionname, items.sessiondesc, segments.starttime, segments.endtime, items_roads.item_id, items_roads.road_id FROM items JOIN items_roads ON (items_roads.road_id=".$ttrack." AND items_roads.item_id = items.id) JOIN segments ON (items.segment_id = segments.id )"); while($row4 = mysql_fetch_array($result4)) { $starttime = $row4['starttime']; $tstartime = date("Y-m-d g:i a", strtotime($starttime)); #echo $tstartime; if ($tstartime == "2009-08-10 4:00 pm") { echo ''.$row4['sessionname'].''; break; } } echo ' '; if($i == 1) { echo "
"; //echo "NETWORKING EVENT HALL A&B
5:00 PM - 6:30 PM"; echo '

 

'; echo "
"; echo "August 11, 2009"; echo "
"; //echo "NETWORKING BREAKFAST HALL C&D
7:30 AM - 8:30 AM"; echo '

 

'; echo "
"; } $result5 = mysql_query("SELECT items.id, items.sessionname, items.sessiondesc, segments.starttime, segments.endtime, items_roads.item_id, items_roads.road_id FROM items JOIN items_roads ON (items_roads.road_id=".$ttrack." AND items_roads.item_id = items.id) JOIN segments ON (items.segment_id = segments.id )"); while($row5 = mysql_fetch_array($result5)) { $starttime = $row5['starttime']; $tstartime = date("Y-m-d g:i a", strtotime($starttime)); #echo $tstartime; if ($tstartime == "2009-08-11 8:30 am") { echo ''.$row5['sessionname'].''; break; } } echo ' '; if($i == 1) { echo "
"; //echo "NETWORKING BREAK EXHIBIT HALL
10:00 AM - 10:30 AM"; echo '

 

'; echo "
"; } $result6 = mysql_query("SELECT items.id, items.sessionname, items.sessiondesc, segments.starttime, segments.endtime, items_roads.item_id, items_roads.road_id FROM items JOIN items_roads ON (items_roads.road_id=".$ttrack." AND items_roads.item_id = items.id) JOIN segments ON (items.segment_id = segments.id )"); while($row6 = mysql_fetch_array($result6)) { $starttime = $row6['starttime']; $tstartime = date("Y-m-d g:i a", strtotime($starttime)); #echo $tstartime; if ($tstartime == "2009-08-11 10:30 am") { echo ''.$row6['sessionname'].''; break; } } echo ' '; if($i == 1) { echo "
"; //echo "NETWORKING LUNCH HALL C&D
12:00 PM - 2:00 PM"; echo '

 

'; echo "
"; } $result7 = mysql_query("SELECT items.id, items.sessionname, items.sessiondesc, segments.starttime, segments.endtime, items_roads.item_id, items_roads.road_id FROM items JOIN items_roads ON (items_roads.road_id=".$ttrack." AND items_roads.item_id = items.id) JOIN segments ON (items.segment_id = segments.id )"); while($row7 = mysql_fetch_array($result7)) { $starttime = $row7['starttime']; $tstartime = date("Y-m-d g:i a", strtotime($starttime)); #echo $tstartime; if ($tstartime == "2009-08-11 2:00 pm") { echo ''.$row7['sessionname'].''; break; } } echo ' '; if($i == 1) { echo "
"; //echo "NETWORKING BREAK
3:30 PM - 4:00 PM"; echo '

 

'; echo "
"; //echo "EXHIBIT HALL CLOSES
4:00 PM"; echo '

 

'; echo "
"; } $result8 = mysql_query("SELECT items.id, items.sessionname, items.sessiondesc, segments.starttime, segments.endtime, items_roads.item_id, items_roads.road_id FROM items JOIN items_roads ON (items_roads.road_id=".$ttrack." AND items_roads.item_id = items.id) JOIN segments ON (items.segment_id = segments.id )"); while($row8 = mysql_fetch_array($result8)) { $starttime = $row8['starttime']; $tstartime = date("Y-m-d g:i a", strtotime($starttime)); #echo $tstartime; if ($tstartime == "2009-08-11 4:00 pm") { echo ''.$row8['sessionname'].''; break; } } echo ' '; if($i == 1) { echo "
"; //echo "OFF-SITE NETWORKING EVENT
6:00 PM - 8:30 PM"; echo '

 

'; echo "
"; echo "August 12, 2009"; echo "
"; //echo "NETWORKING BREAKFAST HALL C&D
7:30 AM - 8:30 AM"; echo '

 

'; echo "
"; } $result9 = mysql_query("SELECT items.id, items.sessionname, items.sessiondesc, segments.starttime, segments.endtime, items_roads.item_id, items_roads.road_id FROM items JOIN items_roads ON (items_roads.road_id=".$ttrack." AND items_roads.item_id = items.id) JOIN segments ON (items.segment_id = segments.id )"); while($row9 = mysql_fetch_array($result9)) { $starttime = $row9['starttime']; $tstartime = date("Y-m-d g:i a", strtotime($starttime)); #echo $tstartime; if ($tstartime == "2009-08-12 8:30 am") { echo ''.$row9['sessionname'].''; break; } } echo ' '; if($i == 1) { echo "
"; //echo "NETWORKING BREAK EXHIBIT HALL
10:00 AM - 10:30 AM"; echo '

 

'; echo "
"; } $result10 = mysql_query("SELECT items.id, items.sessionname, items.sessiondesc, segments.starttime, segments.endtime, items_roads.item_id, items_roads.road_id FROM items JOIN items_roads ON (items_roads.road_id=".$ttrack." AND items_roads.item_id = items.id) JOIN segments ON (items.segment_id = segments.id )"); while($row10 = mysql_fetch_array($result10)) { $starttime = $row10['starttime']; $tstartime = date("Y-m-d g:i a", strtotime($starttime)); #echo $tstartime; if ($tstartime == "2009-08-12 10:30 am") { echo ''.$row10['sessionname'].''; break; } } echo ' '; if($i == 1) { echo "
"; //echo "CLOSING LUNCHEON PLENARY HALL C&D
12:00 PM - 2:00 PM
Seated/plated lunch"; echo ' '; echo "
"; //echo "AGENCY BREAKOUT MEETINGS HALL C&D, BALLROOMS A-E, MEETING ROOMS 550-558 & ROTUNDA"; echo '

 

'; echo "

 

"; echo "
<.html mysql_close($con); ?>
Back to GovEnergy site