function get1fromtable($t,$w){
global $sqli;
$sql="SELECT * FROM $t WHERE $w LIMIT 1";
$result=mysqli_query($sqli,$sql);
if (mysqli_num_rows($result)!=0){
$res= mysqli_fetch_assoc($result);
return($res);
} else {
return false;
}
}
function getfromtable($t,$w){
global $sqli;
$res=array();
$sql="SELECT * FROM $t WHERE $w";
$result=mysqli_query($sqli,$sql);
//echo $sql;
if (mysqli_num_rows($result)!=0){
while ($r= mysqli_fetch_assoc($result)){
$res[]=$r;
}
return($res);
} else {
return false;
}
}
function getfromselect($s){
global $sqli;
$res=array();
$sql=$s;
$result=mysqli_query($sqli,$sql);
//echo $sql;
if (mysqli_num_rows($result)!=0){
while ($r= mysqli_fetch_assoc($result)){
$res[]=$r;
}
return($res);
} else {
return false;
}
}
function getfromtablebyid($t,$w){
global $sqli;
$res=array();
$sql="SELECT * FROM $t WHERE $w";
$result=mysqli_query($sqli,$sql);
if (mysqli_num_rows($result)!=0){
while ($r= mysqli_fetch_assoc($result)){
$res[$r['id']]=$r;
}
return($res);
} else {
return false;
}
}
?>
kino in der reitschule
EthnoKino presents: Roads/Routes
Nikolaus Geyrhalter , Österreich, 2019, OV /e, 115 Minuten
Earth
Several billion tons of earth are moved annually by humans - with shovels, excavators or dynamite. Nikolaus Geyrhalter observes people in mines, quarries, large construction sites in a constant struggle to appropriate the planet.
Masters in Bern: Field Recording with Reto Stamm
“The Iron Ministry”, as an example of sensory ethnography, will open the Masterclass of experienced location sound mixer and sound designer Reto Stamm. The next day (4th of March) Reto Stamm will give practical and theoretical inputs on the role of sound within documentary and ethnographic film projects in a day-long workshop at the Institute of Social Anthropology.