limit 0,10 within SELECT ..... FROM ......
I run PostgreSQL and have some questions:
How come
$query = "SELECT id, tittel, dato, kilde, referat FROM nyheter order by id desc limit 0,10";
Does not display any posts in my news script, but
$query = "SELECT id, tittel, dato, kilde, referat FROM nyheter order by id desc limit 10";
Shows the last 10.?
And:
How come
$query = "SELECT id, tittel, dato, kilde, referat FROM nyheter order by id desc limit 10,20";
Displays posts 5 to 14, and not 10 to 20?!
Regards
Paul Ottar Tornes
Probably because you're really wanting to do:
SELECT id, tittel, dato, kilde, referat
FROM nyheter ORDER BY desc LIMIT 10, 0
(i.e. got the arguments the wrong way round) It's much more intuitive
to use the "LIMIT n OFFSET m" syntax.
Lee.
Paul Ottar Tornes writes:
Show quoted text
I run PostgreSQL and have some questions:
How come
$query = "SELECT id, tittel, dato, kilde, referat FROM nyheter order by id desc limit 0,10";
Does not display any posts in my news script, but
$query = "SELECT id, tittel, dato, kilde, referat FROM nyheter order by id desc limit 10";
Shows the last 10.?And:
How come
$query = "SELECT id, tittel, dato, kilde, referat FROM nyheter order by id desc limit 10,20";
Displays posts 5 to 14, and not 10 to 20?!