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
Film & Musik 2014
Mit musikalischer Live-Begleitung, 60 Minuten
Bild & Musik zum Planungsprozess
Bilder zum Planungsprozess und Dokumentation zur performativen Intervention vom 4. September 2014 auf der Schützenmatte.
Mit musikalischer Live-Begleitung von «Hextatic Piano» - Marco Dalpane, piano:
Philip Glass Wichita Vortex Sutra (1988) / William Duckworth The Time Curve Preludes no. 1, no. 2, no. 13, no. 24 (1979) / Hans Otte The Book of Sounds no.1, no. 2 (1979-82) / John Cage In a Landscape (1948) / Marco Dalpane Notturno (2010) / Claude Vivier Et je reverrai cette ville etrange (1981) / Marco Dalpane Mapping the Sky (2011) / David Lang Wed (2011) / Radiohead (arr. M. Dalpane) Pyramid Song (2001) Everything in Its Right Place (2000) / Simeon ten Holt Natalon in E – I Sostenuto (1976-79)