\n"; ?> Shotokan.cz http://www.shotokan.cz/ Sportovn klub karate Shotokan Neratovice cs Nepodařilo se připojit k databázi.\n"; else: mysql_query("SET character_set_client=cp1250"); mysql_query("SET character_set_connection=cp1250"); mysql_query("SET character_set_results=cp1250"); $today = Date("Ymd"); $result = MySQL_Query("select clanek_id, typ_clanku, autor, datum_zobrazeni, nadpis, anotace, clanek from clanky where datum_zobrazeni <= $today and datum_zobrazeni > 20020125 and autority ='P' order by datum_zobrazeni DESC"); $i = 1; while ($row = @mysql_fetch_array($result)): echo "\n"; echo "" .$row[nadpis]. "\n"; if($row[typ_clanku] == "zprava"): echo "http://www.shotokan.cz/" .$row[clanek]. "\n"; else: echo "http://www.shotokan.cz/show.php?clanek_id=" .$row[clanek_id]. "\n"; endif; echo "" .$row[anotace]. "\n"; echo "\n"; $i += 1; if ($i>6) break; endwhile; endif; ?>