Displaying select info from database

Posted: Wed Jan 01, 2003 9:17 pm (21 years, 3 months ago)

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

Posted: Wed Jan 01, 2003 10:14 pm (21 years, 3 months ago)

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

Posted: Thu Jan 02, 2003 9:06 am (21 years, 3 months ago)

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.