 |  |  |  |  |  |  |  |
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
advanced alerts apache api archive array autosuggest beginner binary broken cakephp checkbox class clients cms code cron curl database date datepart display dynamic echo email emptydisplayvalue eregi error execute explodefunction file files folder form forms function functions google hack href htaccess html if...loop image include insert ip javasciptvalidation javascript joomla keywords library limit link login mail matching menu mlm multiple mysql object oop password paypal pdf php phpincludeissue query radio random recursion recursive remote script search searchbox server sessions shot smarty sms source space speed sql syntax system table tutorial update upload url validator variable vbulletin video web website youtube
