Koncerty - ostatní

'); // koncerty $query = "SELECT id, mesto, kraj, poznamka, odkaz, DATE_FORMAT(datum,\"%d. %m.\"), DATE_FORMAT(datum,\"%H:%i\"), DATE_FORMAT(datum,\"%Y\"), DATE_FORMAT(datum,\"%w\"), DATE_FORMAT(datum,\"%Y%m%d\") FROM ".$U_CONCERTS_TABLE." WHERE deleted=".$U_DELETED_FALSE." AND type='2' AND substring(datum,1,10) >= substring(NOW(),1,10) AND status=".$U_CONCERTS_ACTIVE." ORDER BY datum ASC"; $result = db_query($query,$link); $result_count = db_num_rows($result); $query_next = "SELECT id FROM ".$U_CONCERTS_TABLE." WHERE deleted=".$U_DELETED_FALSE." AND status=".$U_CONCERTS_ACTIVE." AND substring(datum,1,10) >= substring(NOW(),1,10) AND type='2' ORDER BY datum ASC LIMIT 1"; $result_next = db_query($query_next,$link); list($next_id) = db_fetch_row($result_next,$link); if($result_count>0){ for ($v=0; $v<$result_count; $v++) { list($k_id,$k_mesto,$k_kraj,$k_poznamka,$k_odkaz,$k_datum,$k_cas,$k_rok,$k_den,$k_date) = db_fetch_row($result,$link); if($k_rok>0){ echo ("\n".''.$U_DAYS[$k_den][title].' '.$k_datum.' '.$k_rok.'-'.($k_cas!="00:00" ? '
'.$k_cas.'' : '').''.$k_mesto.'
'.stripslashes($k_poznamka).' '.($k_odkaz=="http://" || $k_odkaz=="" ? "" : '...více').''); }else{ echo ("\n".'?-'.$k_mesto.'
'.stripslashes($k_poznamka).' '.($k_odkaz=="http://" || $k_odkaz=="" ? "" : '...více').''); } } echo ("\n".'

'); }else{ echo('

'); } // / koncerty echo("\n".''); ?>