Michal Belicek wrote:
>
> Petr Filip wrote:
> > MySQL_Select_DB("test");
> > @$vysledek = MySQL_Query("SELECT * FROM kratke ORDER BY CISLO DESC");
> >
> > vim, ze tam ma byt jeste WHERE ... ale nevim co dal :-(
>
> Predem upozornuju ze nejsem PHPista ale ORACLEista :-)
>
> Mozna by stacilo pridat do tabulky KRATKE sloupec DATUM, ve kterem
> bude cas zapisu radku do tabulky nebo cas vzniku clanku. Select pak
> bude treba takto:
Sorry, ted kdyz to po sobe ctu,
SELECT * FROM kratke
WHERE cislo > (SELECT MAX(cislo) - 5 FROM kratke)
ORDER BY cislo DESC
bude mnohem jednodussi, nez pridavat sloupce :-)
--
Michal Belicek
mailto:belicek@asset.sk
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
=- Resistance is futile. You'll be assimilated! =-=-=-=-=-=-=-=-=-=-=
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Startrek =-=-=-=-=-=-=-=-=-=-=-
=- A kdo sympatizuje s Miloslavem Stepanem at se mi neopovazuje =-=-=
-= prijit pod ruku! -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
This archive was generated by hypermail 2.1.2 : 03. 09. 2001, 22:30 CEST