 |  |  |  |  |  |  |  |
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
Views: 457 | Replies: 3
| Thread Tools | Search this Thread |
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for PHP
.htaccess access ajax apache api array beginner binary broken cakephp checkbox class cms code cron curl database date directory display download dynamic echo email encode error file files folder form forms function functions google howtowriteathesis href htaccess html image include insert integration ip java javascript joomla jquery limit link login loop mail menu methods mlm mod_rewrite multiple multipletables mysql oop parse paypal pdf php problem provider query radio random recursion regex remote script search select server sessions sms soap source space speed sql structure syntax system table template tutorial update updates upload url validation validator variable video web xml youtube
