Display limited output from mysql query

use LIMIT into the query. Like this:

$sql= 'SELECT * FROM table LIMIT 5';

will fetch only 5 first records.

$sql= 'SELECT * FROM table LIMIT 5 10';

will fetch 10 records starting from 5.

http://dev.mysql.com/doc/refman/5.1/en/select.html
http://hackmysql.com/case3

Hope this helps.
Addy

The query part is not difficult, but the display part is not clear to me.
Let us say the search result return x output, and the use chose to see 25 output in one page, then depending on x will be the number of pages if x is 100 then we need 4 pages when the user press next he will to the next page, or if he press let us 3 he will jump to page 3.
Shall I make a full query, and put in an array and dsiplay it dynamically, or each time I need to make a query for each page.
Is there any example for that?

Ok, You want to use the pager.

Here is the link for that.

This will display page links based on the data.

http://pear.php.net/package/Pager/redirected

Hope this helps
Addy

use LIMIT into the query. Like this:

$sql= 'SELECT * FROM table LIMIT 5';

will fetch only 5 first records.

$sql= 'SELECT * FROM table LIMIT 5 10';

will fetch 10 records starting from 5.

Thanks
Mehul Panchal

Thank you BenMorel, your code is very helpful