query("SELECT talk_id AS id,authors AS name,title,DATE_FORMAT(starttime,'%H:%i') AS stime,length,DATE_FORMAT(starttime,'%W, %d %M') AS day FROM kongress_IX RIGHT JOIN kongress_IX_timetable ON (id=talk_id) WHERE (accept>=1 AND title!='') OR talk_id<0 ORDER BY starttime,name");
print "
";
$day = '';
while ($r=next_arow()) {
if ($r['name'] == '' and $r['length']<=60) $name = "
COFFEE BREAK
";
elseif ($r['name'] == '' and $r['length']>60 and $r['length']<120) $name = "
LUNCH in the canteen
";
elseif ($r['name'] == '' and $r['length']>=120) $name = "
DINNER and informal conversation in the canteen
";
else $name = "{$r['name']}:";
if ($r['id']==-9) $name = 'Opening by Prof Dr. József Pálinkás (president of the Centre of Arts Humanities and Sciences)';
if ($r['id']==-10) $name = 'Birds of the "Puszta", Hortobágy by Dr. Zsolt Végvári (Hortobagy National Park)';
if ($r['id']==-11) $name = 'Welcome Party';
if ($r['id']==-12) {
$name = 'Dr. Zoltán Barta:';
$r['title'] = 'Welcome notes';
}
if ($r['id']==-14) $name = 'Reception opens';
if ($day == '') {
$day = $r['day'];
print "
query("SELECT name,institute,title,abstract,web,CONCAT(TRIM(SUBSTRING(name,-4)),TRIM(SUBSTRING(title,1,3))) AS id FROM kongress_IX WHERE accept=2 ORDER BY name");
while ($r = next_arow()) {
print "{$r['name']} ({$r['institute']})