breaking up results to view n records at a time

[Anon]

Hi

What is the easiest way to break up a mysql search result to view only 10 records at a time (or whatever number of records you specify) and with a link to the next 10 results?

Thanks
Regards
Glen

[Anon]

Check out my tutorial at http://php.socket7.net called "Improved Next/Prev Buttons"

Hope this helps!

Brett

[Anon]

Hi!

use this syntaxs!

select * from tablename limit 0,10

or

select * from tablename limit 10,10

Read the mySQL manual (select syntax,7.12)!
[LIMIT [offset,] rows]

by CsorPe LuZers