» Detailinfos
'.$result['title'].' '.$result['author'].'
'.$result['subtitle'].'

'.nl2br($result['description']).'

'; $subquery = mysql_query("SELECT DATE_FORMAT( date , '%d.%m.' ) AS eventdate, TIME_FORMAT(time, '%H:%i Uhr') AS time, placeid FROM hpk_dates WHERE eventid=".$result['eventid']." ORDER BY date ASC"); $dates = array(); $places = array(); while ($subresult = mysql_fetch_array($subquery)) { $dates[$subresult['placeid']] .= $subresult['eventdate'].' '.$subresult['time'].', '; if (!in_array($subresult['placeid'],$places)) $places[] = $subresult['placeid']; } if (count($places)) { $subquery = mysql_query("SELECT placeid, placetitle FROM hpk_places WHERE placeid IN (".implode($places).")"); while ($subresult = mysql_fetch_array($subquery)) { $id = $subresult['placeid']; echo '

Aufführung/en '.$subresult['placetitle'].':
'.$dates[$id].'

'; } } echo '
'; } ?>

 
www.woltlab.de Biographie | Termine | Musik | Bilder | Presse | Kontakt