Limiting the no. item in a page

[rittwickbanerjee]

Hi All,

 

I just new to this web site  & to this forum

 

I was developing online shopping  cart. On my show products page item of one category is shown in one page. if there is 500 items of one category then the user get puzzled to  search one item in that list.

 

So I want make it page wise

 

like only 50 items will be shown in one page, for the next 50 items the user have to click next,

 

but there must be only one page linking the database for items & showing it. If any one can & then please give me the source code

[trq]

You'll want to search for php pagination examples[/url], google returned some 2 million results.

[rittwickbanerjee]

I just want to limit the maximum number of item in a page.

 

For example in a shopping cart there are many items of different category

 

like Product X of Category Y is 500

so if i make query to the database "select product from productlist where productname='X' and category='y';

 

then the ouput will 500 item if those items are displayed in one page then the user will puzzled in searching of a product named X.1

 

so I want to make those items to be displayed in multiple pages.

 

like productinfo.php?page=1 >> It will output first 50 item from the list

    productinfo.php?page=2 >> It will output next 50 items & so on

 

So If any one help mefor this then I will great full to him/her.

 

Thank you

Rittwick Banerjee

[trq]

I just want to limit the maximum number of item in a page.

 

Yes, I am aware of what it is you want to do.

 

So If any one help mefor this then I will great full to him/her.

 

I told you what the term to search for is, seek and you shall find.

[Daniel0]

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