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
rajeesh_rsn 0 Posting Whiz in Training
kanaku 60 Posting Whiz
Hallu again rajeesh! SkyVValker had the same problem about limiting the display. His question was already answered here by DiGSGRL. :)
php-freelancer -7 Newbie Poster
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
rajeesh_rsn 0 Posting Whiz in Training
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.