How to apply Limit on Result of Records.

[man12_patil3]

Select * from tabName Limit 25

 

by above query i get 25 rows than i want to add Limit in this result for pagination 5 record per page .

 

How it is possible ??

 

 

 

[AyKay47]

this site has a nice tutorial on pagination..

http://www.phpfreaks.com/tutorial/basic-pagination

[web_craftsman]

limit 0,5  - first five

limit 5,5 - skip first five, select next five

limit 10,5 - skip ten

 

you need to write code like this:

$page = isset($_GET['page']) ? (int) $_GET['page'] : 0;
$query = 'Select * from tabName Limit ' . ($page *5) . ', 5';

[man12_patil3]

I think this is not my solution. i already implicated pagination in my script.

 

 

i want to fetch 25 Product from table  then apply on that pagination .......

 

 

 

 

[AyKay47]

if you already did it then why are you asking how to do it?

[man12_patil3]

i want to fetch 25 Product from table  then apply on that pagination .......

 

and i don't now the how many record in table....

 

[AyKay47]

read the tutorial in the link i gave you

[web_craftsman]

Do inner 25 records by 5 per page  using javascript 

[fenway]

Or just a subquery.