DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)
-   PHP (http://www.daniweb.com/forums/forum17.html)
-   -   Help for MySQl display (http://www.daniweb.com/forums/thread165907.html)

rajeesh_rsn Jan 4th, 2009 12:43 am
Help for MySQl display
 
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

kanaku Jan 4th, 2009 1:49 am
Re: Help for MySQl display
 
Hallu again rajeesh! SkyVValker had the same problem about limiting the display. His question was already answered here by DiGSGRL. :)

php-freelancer Jan 4th, 2009 12:21 pm
Re: Help for MySQl display
 
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 Jan 5th, 2009 10:39 am
Re: Help for MySQl display
 
Quote:
Originally Posted by php-freelancer (Post 770594)
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


All times are GMT -4. The time now is 11:37 pm.

Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC