|
![]() |
|
$db = mysql_connect("localhost","webuser");
mysql_select_db("gfkl2004",$db);
$sql="SELECT Sum(AttendSteel) AS AttendSteel,
Sum(AttendBrewery) AS AttendBrewery,
Sum(AttendDortmundExperience) AS AttendDortmundExperience,
Sum(AttendMining) AS AttendMining,
Sum(AttendDASA) AS AttendDASA,
Sum(AttendDASA2) AS AttendDASA2
FROM corrections
WHERE Approved = 1;";
$result = mysql_query($sql,$db);
$row = mysql_fetch_array($result);
$AttendSteelCorr = $row["AttendSteel"];
$AttendBreweryCorr = $row["AttendBrewery"];
$AttendDortmundExperienceCorr = $row["AttendDortmundExperience"];
$AttendMiningCorr = $row["AttendMining"];
$AttendDASACorr = $row["AttendDASA"];
$AttendDASA2Corr = $row["AttendDASA2"];
$sql="SELECT Sum(participants.AttendSteel) AS AttendSteel,
Sum(participants.AttendBrewery) AS AttendBrewery,
Sum(participants.AttendDortmundExperience) AS AttendDortmundExperience,
Sum(participants.AttendMining) AS AttendMining,
Sum(participants.AttendDASA) AS AttendDASA,
Sum(participants.AttendDASA2) AS AttendDASA2
FROM participants LEFT OUTER JOIN corrections ON participants.RegNr = corrections.RegNr
WHERE (participants.Approved = 1) AND (corrections.RegNr IS NULL);";
$result = mysql_query($sql,$db);
$row = mysql_fetch_array($result);
?>
Social Program - Organized TripsThe GfKl offers some social highlights during the 28th annual conference. Due to the huge amount of planned sessions, the individual excursions will be scattered over all conference days. Some of the proposed places are also part of the "Route of Industrial Heritage" (Route der Industriekultur). Steel Coking Plant HansaAfter the plant was shut down in 1992, (it opened in 1928) nature managed to regain a part of the complex. As an "accessible sculpture," the complex provides unusual insights into its past industrial history, as well as into a constantly changing kind of industry. On the hands-on route through the complex, the visitor can learn about technology, history, and the forms of plant life that have begun to develop in the region. A visit to the impressive compressor hall with its enormous machines is also integrated into this path.
http://www.route-industriekultur.de/primaer/a07/a07_e.htm The coking plant is easy to reach by public transport. (S-Bahn S1 to Dortmund main station (Dortmund Hauptbahnhof (HBF), the metro U47 to "Parsevalstraße" (direction Westerfilde), exit "Mailoh" (in the direction of the train to Westerfilde)) Adress: Emscherallee 11, 44369 Dortmund
Brewery Inspection and Beer TestThe triangle trade of steel, coal, and beer brought a period of prosperity to the old "Free Imperial City of Dortmund". With the brewery inspections the brewing master introduces the guests into the secrets of the beer brewing and into the history of the Hoevels house brewery. Apart from the detailed information in the brewery - which not necessarily has to be dry - you can take the opportunity to test the three different Hoevels beers. The brewery lies in the city of Dortmund, near the theater. It is easy to reach by public transport. (S-Bahn S1 to Dortmund main station (Dortmund Hauptbahnhof (HBF), then about 15 minutes to walk (turn to the right in front of the station and follow the great circle streets (Königswall, Hoher Wall), otherwise you can take the metro to "Stadtgarten" and walk some minutes, the brewery lies behind the theater (green triangle ball-shaped roof)) Adress: Hoher Wall 5-7, 44137 Dortmund
The Dortmund Experience / Dortmund Yesterday and TodayDiscover the highlights of Dortmund by coach. Come with us on a tour of Dortmund
as it was in the past and as it is today.
You will see many sights, old and new, of Dortmund and its suburbs, you will hear
many facts, figures and stories from Dortmund's history. And you will notice
everywhere the structural and economic changes taking place in our town. Discover
not only the Port of Dortmund - the largest canal port in Europe -, the Borsigplatz
- birthplace of the football club Borussia Dortmund - and the Lanstrop "Egg"
but also idyllic miners houses and medieval moated castles like "Haus Wenge"
with its park. And during a break you can either explore the former coal-mine
"Zeche Zollern II/IV"
(see also "Individual trips") or simply relax with coffee and cake at the restaurant "Pferdestall".
German mining museum in BochumThe German Mining Museum Bochum (Deutsches Bergbaumuseum) is one of Germany's
most popular museums being visited by almost 400,000 people a year, and
the most important mining museum worldwide. Several exhibitions and an
original subterranean visiting mine offer an insight into the world of
coal mining.
http://www.route-industriekultur.de/primaer/m01/m01_e.htm The mining museum is also easy to reach by public transport. (S-Bahn S1 to Bochum main station (Bochum Hauptbahnhof (HBF) (direction Düsseldorf)), the metro U35 to "Bergbaumuseum" (direction Herne), follow the signs in the station) Adress: Am Bergbaumuseum 28, 44791 Bochum
DASAThe German Occupational Safety and Health Exhibition (DASA) is a place to visit for an educational experience. Information can be found here about the world of work and its importance in society. The DASA was opened in 1993 as part of the Federal Institute for Occupational Safety and Health. You will visit an exhibition involving plenty of leisure activity and to find out how the future will look in view of the changes taking place in the world of work.
http://www.route-industriekultur.de/primaer/m02/m02_e.htm The DASA is about 15 minutes to walk from the campus and the conference site. Ohterwise one can get there by train (S-Bahn, S1, "Dorstfeld-Süd", one station before the university if you come from Dortmund HBF), follow the signs in the station, the DASA lies at the "university-end" of the station. Otherwise you can get there by bus (line 447, direction Dorstfeld/Huckarde, to "Bundesanstalt für Arbeitsschutz", one stop after the university) Adress: Friedrich-Henkel-Weg 1 - 25, 44149 Dortmund
Social Program during the Conference: LinksDortmund and the Ruhr area (Ruhrgebiet) have many interesting places worth to visit. We give some examples if you are interested to see some unknown aspects of this area during or around the conference: Individual Trips. The Working Group Data Analysis in Archaeology (AG Datenanalyse in der Archäolgie) offers a special excursion on friday, March 12th, 2004. One will visit the German Mining Museum in Bochum (see above) as well as the Archaeological Museum of Westphalia in Herne and some other interesting points in Dortmund and its neighbourhood: Archaeological excursion.
Latest change: January 28, 2003 [M.T.]
|