2 replies to this topic

[kwahedi]

Hi
i need to have code of pagination for my project
can some help me?????/
i want to drive out the information from my database by group number
each group have 30 person ,there for i want to 5 person in each page:rolleyes::rolleyes::rolleyes:

[WingedPanther]

Moved to the correct forum (this is NOT a tutorial).

It will depend somewhat on your database structure, which type of database you are using for the back-end, etc.

[BlaineSch]

For example a MSSQL page 1 with 10 results would look similar to:

SELECT
    x.*
FROM
    (
        SELECT
            *,
            ROW_NUMBER() OVER(ORDER BY id DESC) AS rowNumber
        FROM
            [table]
    ) AS x
WHERE
    x.rowNumber BETWEEN 1 AND 10

MySQL looking similar to

SELECT * FROM `table` LIMIT 0, 10