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
ciné liminal
A collaboration with the SNF-Sinergia Project «Mediating the Ecological Imperative», English, 90 Minuten
Geological Filmmaking: Screening + Masterclass with Sasha Litvintseva
«Every film image is geological. As a technical medium derived from the metals and minerals extracted from the earth, every moving image is materially embedded in the world it records.» A masterclass with artist, filmmaker and writer Sasha Litvintseva, whose work is situated on the uncertain thresholds of the perceptible and the communicable, organism and environment, and knowledge regimes and power, at the intersection of media, ecology and the history of science. The event will include the screening of her films, Salarium (2017) and Asbestos (2016).