4WebHelp
 FAQ  •  Search  •  User Groups  •  Forum Admins  •  Smilies List  •  Statistics  •  Rules   •  Login   •  Register
Toggle Navigation Menu

 Displaying select info from database
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic
Author Message
billdavies
Senior WebHelper
Senior WebHelper


Joined: 22 Jan 2002
Posts: 107
Location: UK

PostPosted: Wed Jan 01, 2003 9:17 pm (14 years, 9 months ago) Reply with QuoteBack to Top

Hi,

I am currently going through a tutorial (http://hotwired.lycos.com/webmonkey/99/21/index3a.html) and I am trying to work out how you can display only a portion of the database information. What I mean is something like you see on CD Wow (eg http://www2.cd-wow.com/bargain_basement.php?bottomlimit=24&toplimit=48) where they use bottom and top limits. Is this how you do it as it didn't seem to work when I tried.

Thanks

Bill
OfflineView User's ProfileFind all posts by billdaviesSend Personal MessageVisit Poster's WebsiteMSN Messenger
adam
Forum Moderator & Developer



Joined: 26 Jul 2002
Posts: 704
Location: UK

PostPosted: Wed Jan 01, 2003 10:14 pm (14 years, 9 months ago) Reply with QuoteBack to Top

you can add LIMIT on the end of your query. Adding LIMIT 15,35 will display rows 15-35.

________________________________
It's turtles all the way down...
OfflineView User's ProfileFind all posts by adamSend Personal MessageVisit Poster's Website
Darren
Team Member



Joined: 05 Feb 2002
Posts: 549
Location: London

PostPosted: Thu Jan 02, 2003 9:06 am (14 years, 9 months ago) Reply with QuoteBack to Top

The trick is though using something like PHP to build these querys on the fly depending on the number of results, outputting the necessary buttons/links for next /previous pages etc.
OfflineView User's ProfileFind all posts by DarrenSend Personal MessageVisit Poster's Website
Display posts from previous:      
Post New TopicReply to Topic
View Previous Topic Print this topic View Next Topic


 Jump to:   




You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot edit your posts in this forum.
You cannot delete your posts in this forum.
You cannot vote in polls in this forum.


Page generation time: 0.081727 seconds :: 18 queries executed :: All Times are GMT
Powered by phpBB 2.0 © 2001, 2002 phpBB Group :: Based on an FI Theme