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

Recommended Answers

All 3 Replies

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.