RĂ©szletes filmkeresƑ CĂ­m (rĂ©szlet)
Cégnév (részlet)
GyĂĄrtĂĄs Ă©ve
ForgatĂĄs Ă©ve
Népcsoport/nemzetiség név (részlet) '.keve_nepcsoport_lista().'
Tartalomban szereplƑ szĂł (rĂ©szlet)
Földrész név '.keve_foldresz_lista().'
Orszåg név '.keve_orszag_lista().'
Lokalitås név '.keve_lokalitas_lista().'
Kulcsszó szó (részlet)
Személy név (részlet)

EgyszerƱ filmkeresƑ >>

'; keve_db_connect(FALSE); return $output; } function keve_nepcsoport_lista() { $output.= ""; return $output; } function keve_foldresz_lista() { $output.= ""; return $output; } function keve_orszag_lista() { $output.= ""; return $output; } function keve_lokalitas_lista() { $output.= ""; return $output; } function keve_advanced_search_film() { $url = url('adatbazis'); $output = keve_advanced_search_page(); keve_db_connect(); $output .= '

Filmkeresé talålatok: "'.$_POST['cim'].'"

'; //bejovo adatok a formbol. feldolgozas $cim=trim($_POST['cim']); $cim=mb_strtoupper($cim,"utf-8"); $kulcsszo=$_POST['kulcsszo']; $ceg=$_POST['ceg']; $ceg=strtoupper($ceg); if ($_POST['nemzetiseg_select']!="nincs") $nemzetiseg=$_POST['nemzetiseg_select']; else $nemzetiseg=$_POST['nemzetiseg']; $nemzetiseg=strtoupper($nemzetiseg); $tartalom=$_POST['tartalom']; $gyartas_eve=$_POST['gyartas_eve']; $forgatas_eve=$_POST['forgatas_eve']; $nev=$_POST['szemely']; $nev=strtoupper($nev); $talalat=1; $vanszemely=1; $van=1; //kereses elso kor $keres = 'SELECT DISTINCT film.id as filmid, film.magyar_cim as magyarcim, film.eredeti_cim, film.hosszusag as hosszusag, film.gyartas_ideje_tol as gyartastol, film.gyartas_ideje_ig gyartasig FROM film WHERE '; // $keres .= 'kulcsszavak like \'%'.$kulcsszo.'%\' AND '; $keres .= '(upper(eredeti_cim) like \'%'.$cim.'%\' OR upper(magyar_cim) like \'%'.$cim.'%\' OR upper(angol_cim) like \'%'.$cim.'%\' OR upper(eredeti_alcim) like \'%'.$cim.'%\' OR upper(magyar_alcim) like \'%'.$cim.'%\' OR upper(angol_alcim) like \'%'.$cim.'%\' OR upper(eredeti_sorozatcim) like \'%'.$cim.'%\' OR upper(magyar_sorozatcim) like \'%'.$cim.'%\' OR upper(angol_sorozatcim) like \'%'.$cim.'%\') AND ( upper(angol_tartalom) like \'%'.$tartalom.'%\' OR upper(magyar_tartalom) like \'%'.$tartalom.'%\' ) '; $keres=$keres." ORDER BY magyarcim"; if (!$eredmeny = mysql_query($keres)) { return $output.'Hiba a keresben.'; } if (mysql_num_rows($eredmeny)==0) { $output .="Nincs talalat."; //include("vissza.php"); return $output; } $output .= ''; mysql_free_result($eredmeny); // include("vissza.php"); keve_db_connect(FALSE); return $output; } function keve_szemelylista($tabla,$film_id,$nev) { $alkeres=" SELECT szemely.id FROM szemely,film,".$tabla." WHERE film.id='".$film_id."' AND ( upper(vezeteknev) LIKE '%".$nev."%' OR upper(vezeteknev2) LIKE '%".$nev."%' OR upper(keresztnev) LIKE '%".$nev."%' OR upper(keresztnev2) LIKE '%".$nev."%' OR upper(muvesznev) LIKE '%".$nev."%' ) AND film.id=".$tabla.".film_id and szemely.id=".$tabla.".szemely_id "; $aleredmeny=mysql_query($alkeres); if (mysql_num_rows($aleredmeny)!=0) { return 1; } else { return -1; } } Dialektus Fesztival 2008

 

[Back]
Trailer

Chicagoblok, verhalen uit de lift (Chicagoblock, Stories from the Elevator)

Film
Title of the film Original title: Chicagoblok, verhalen uit de lift
English title: Chicagoblock, Stories from the Elevator
Hungarian title: A „Chicago tömbhĂĄz”, avagy törtĂ©netek a liftbƑl

Production and shooting info Country of the production: Netherlands - nl
Year of production: from 2007 to 2008
Year of shooting: 2007
Length of the film: 65 min
Colouring: colour
Standard format: DigiBeta
Original language: Flemish
 Thai
 English
Language of subtitle: Hungarian

Description of the content On the ‘wrong’ side of Antwerp, on the left bank of the Scheldt, you’ll find a block of flats that rises above its surroundings. The people of Antwerp have named it ‘Chicagoblock’ and see it as a place where you would rather not go. In this building poor Belgians live next to immigrants, over 35 nationalities people the 25 stories. In this concrete beehive a camera is posted in the elevator where the occupants are passing in front of the lense. The camera follows some of them home and tells their story: Great and small stories that rise above their vicinity.

Credits Made by: Ingeborg Jansen
Expert: Manon Sluijs
Producer: Rob Vermeulen
 Nadadja Kemper
Sound: Carla Meijs

Company / Institution Production: Holland Harbour Productions bv

Ethnicity and locality Etnic group: Belgian
 Thai
 Moroccan
 African
Continent: Western Europe
Country: Belgium - be
Location
 (City, village, region, mountains, etc.): Antwerp

Tipology Type: non-fiction film
Form: documentary film
Topic: city and multicultural communities

Related sciences Social science: sociology


Keyword: migration
 underclass
 urban life

Photos
Macromedia Flash is required. Download Macromedia Flash.