Posted by pritaeas on 04/19/07 09:43

"Man-wai Chang" <toylet.toylet@gmail.com> wrote in message
news:462733e6$1@127.0.0.1...
> I would like to do something like this:
>
> select * from myTable where ... pagesize 10 page 1
>
> How could I do it elegantly in:
>
> 1. PHP+MySQL before MySQL 5 (without stored procedures)
> 2. MySQL alone (with stored procedures)
>
> --
> iTech Consulting Services Limited
> Expert of ePOS solutions
> Website: http://www.itech.com.hk (IE only)
> Tel: (852)2325 3883 Fax: (852)2325 8288

Hi. You can use the query to do it for you, without PHP or stored
procedures.

SELECT * FROM table LIMIT 0, 10

Where 0 is the start record, and 10 your pagesize.

Regards, Hans

[Back to original message]