 |  |  |  |  |  |  |  |
Help for MySQl display
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved
 |
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
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
•
•
Join Date: Jan 2007
Posts: 276
Reputation: 
Solved Threads: 15
Posting Whiz in Training
Hallu again rajeesh! SkyVValker had the same problem about limiting the display. His question was already answered here by DiGSGRL. 
If you know ASP, you can save other daniweb members from idiots like me by helping out in this forum.
Visit this thread if your username starts with one of the following letters: B D F H J L N P R T X Y Z.
Visit this thread if your username starts with one of the following letters: B D F H J L N P R T X Y Z.
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
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
•
•
•
•
Originally Posted by php-freelancer 
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
|
Similar Threads
- Clean Previous Next Script for MySQL results (PHP)
- Image upload from, Form into Folder and MySQL (PHP)
- Please I need help on image upload to mysql and display in browser (PHP)
- How to make an MySQL Table Jion and Display it in JSP (JSP)
- Php Mysql Shopping Cart (PHP)
- Is it possible to create a pie chart with JSP from the data of MySQL? (JSP)
Other Threads in the PHP Forum
- Previous Thread: what is php stands for
- Next Thread: Create a script that checks if "file.txt" is chmoded 777, and if mod_rewrite = on
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
apache api array autocomplete beginner binary body broken cakephp class cms code cron curl database dataentry date date/time display duplicates dynamic ebooks email emptydisplayvalue error execute explodefunction file firstoptioninphpdroplist folder form forms function functions google href htaccess html image include ip javasciptvalidation javascript joomla keywords limit link list login matching mediawiki menu msqli_multi_query multiple mycodeisbad mysql navigation number oop parameter paypal pdf php phpincludeissue query random recourse recursive regex script search seo server sessions shot source sp space speed sql static subdomain subscription system table tag tutorial tutorials update upload url validator variable vbulletin video web webdesign white xml youtube