Problem sa kombinacijom ORDER BY i LIMIT

Problem sa kombinacijom ORDER BY i LIMIT 24.02.2004. u 18:17 · pre 276 meseci #1

Pozdrav!

Imam problem sa sledecim upitom:

Code:
SELECT * FROM vesti WHERE pismo='1' ORDER BY datum DESC LIMIT 3, 6

Kada je LIMIT 0, 3 radi ok, ali za sledece daje neocekivane rezultate (konkretno za ovaj daje 5 redova).

U dokumentaciji sam pronasao da je ova kombinacija malo zahebana. Da li je neko resavao ovako nesto sql-om, ili da ga provlacim kroz while petlju u php-u?

// edit: pogresno sam skontao limit parametre! Izvinjavam se !
problem resen.

Potpis

Pop Servis "Paradise Tours"
Java User Group Karlsruhe
IT Dan - Srbija

Officer, I saw the driver who hit me - his name was Johnny Walker.

Re: Problem sa kombinacijom ORDER BY i LIMIT 28.04.2005. u 20:59 · pre 261 mesec #2

E, cekaj ja imam slican / isti problem...
Upit:

Code:

SELECT * FROM tablename ORDER BY field LIMIT 0,6

mi vraca ok rezultat
dok:

Code:

SELECT * FROM tablename ORDER BY field LIMIT 4,6

vraca kao da je limit setovan na 4,MAXRecord...

zasto?

Potpis

And don't be mad at me for crying for humanity,
call it pretensions but I got good intentions,
to keep my sanity, I'm hoping, fuck, there's gotta be
an answer to their strategies and their evil inventions... ~Looptroop

Re: Problem sa kombinacijom ORDER BY i LIMIT 28.04.2005. u 21:02 · pre 261 mesec #3

aaa drugi broj je length... ;)
stvarno moram da naucim da citam pazljivije...

Potpis

And don't be mad at me for crying for humanity,
call it pretensions but I got good intentions,
to keep my sanity, I'm hoping, fuck, there's gotta be
an answer to their strategies and their evil inventions... ~Looptroop

Forum kao aplikacija na telefonu

Srodne teme