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 Festival: Resilient
Documentary by Valentina Shashivari
, Switzerland, 2022, Swiss German with English Subtitles, 17 Minuten
Mountain Flesh
In a Swiss mountain village, hikers head out, a fountain splashes reassuringly and a churchwarden prepares a mass. Debut director Valentina Shasivari evokes the calm of this serene landscape with tightly framed shots in contrast-rich black-and-white. But the soundtrack, with its creaks and crackles emanating from underground, beneath the mountains, raises questions and a creeping, ominous feeling. There’s something going on here, but what is it? Men with high-tech measuring instruments pepper the landscape, and local people study their surroundings intensely. An ecological dystopia about a community living under constant threat.