Thread: limit

Paul Ottar Tornes wrote:

> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_00B3_01C2813F.1EFB1790
> Content-Type: text/plain;
>     charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> How come=20
>     $query =3D "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 =3D "SELECT id, tittel, dato, kilde, referat FROM nyheter
> order =
> by id desc limit 10";
> Shows the last 10.?
>
> And:
>
> How come
>     $query =3D "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
>
> ------=_NextPart_000_00B3_01C2813F.1EFB1790
> Content-Type: text/html;
>     charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
>
>
>
>
>
>
> How come
>
>     $query =3D "SELECT id, =
> tittel,=20
> dato, kilde, referat FROM nyheter order by id desc limit 0,10";
>
> Does not display any posts in my news scri=
> pt,=20
> but
>
>     $query =3D "SELECT id, =
> tittel,=20
> dato, kilde, referat FROM nyheter order by id desc limit 10";
>
> Shows the last 10.?
>
>
>
> And:
>
>
>
> How come
>
>     $query =3D "SELECT id, =
> tittel,=20
> dato, kilde, referat FROM nyheter order by id desc limit 10,20";
> Displays posts 5 to 14, and not 10 to=20
> 20?!
>
>
>
> Regards
>
>
>
> Paul Ottar Tornes
>
>
> ------=_NextPart_000_00B3_01C2813F.1EFB1790--
>
>
You must use the OFFSET to do this.

Write your query this way:

$query = "SELECT id, tittel, dato, kilde, referat FROM nyheter order by
id desc offset 9 limit 10";