943,846 Members | Top Members by Rank

Ad:
  • PHP Discussion Thread
  • Marked Solved
  • Views: 538
  • PHP RSS
Jan 4th, 2009
0

Help for MySQl display

Expand Post »
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
Reputation Points: 10
Solved Threads: 0
Posting Whiz in Training
rajeesh_rsn is offline Offline
265 posts
since Sep 2008
Jan 4th, 2009
0

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.
Reputation Points: 70
Solved Threads: 15
Posting Whiz
kanaku is offline Offline
378 posts
since Jan 2007
Jan 4th, 2009
0

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
Reputation Points: 3
Solved Threads: 2
Newbie Poster
php-freelancer is offline Offline
8 posts
since Dec 2008
Jan 5th, 2009
0

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


Very Very thanks for the kind support.... I solved the problem .... Once again Thanks
Reputation Points: 10
Solved Threads: 0
Posting Whiz in Training
rajeesh_rsn is offline Offline
265 posts
since Sep 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in PHP Forum Timeline: what is php stands for
Next Thread in PHP Forum Timeline: Create a script that checks if "file.txt" is chmoded 777, and if mod_rewrite = on





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC