0

Hi ,
I want to show content of tables in a database in a PHP page. And I did it successfully. I had around 1500 rows in that table. Now the problem is the PHP page showing all the 1500 rows in a single page.. Please help me to limit this in to 50 or 75....
Please Help me
Regards
Rajeesh

3
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by rajeesh_rsn
0

Hi rajesh

What i think is you might be writing query like this
u r query : select * from tbl_name where ---.

so it is giving u all the rows in table i.e. 1500.

You just need to modify your query
new query : select * from tbl_name where --- limit 50.

This will limit the selected rows to 50 only.


Try it , I think this will solve u r issue

0

Hi rajesh

What i think is you might be writing query like this
u r query : select * from tbl_name where ---.

so it is giving u all the rows in table i.e. 1500.

You just need to modify your query
new query : select * from tbl_name where --- limit 50.

This will limit the selected rows to 50 only.


Try it , I think this will solve u r issue

Very Very thanks for the kind support.... I solved the problem .... Once again Thanks

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.