View Single Post
Old 01-20-08, 10:42 PM   #5
technoid
Registered User
 
Join Date: Jul 2004
Location: Denton, Texas
Posts: 505
Default Re: MySQL SORT by Column and LIMIT Rows using classic ASP

Quote:
Originally Posted by t3hl33td4rg0n
Personally I always found it annoying when "search results" were limited without any orthodox means of increasing the limit.

Like, searching for an item on siteX returns 900 results with each page only showing 5 items! wtf! lol...

I always try to include an options for sorting, number of results per page, etc.
I ended up providing lots of options for page size, 10, 15, 20, 25, 30, 40, 50, All. That way each person should be able to pick a page size that fills their screen. The page size is stored in a persistent cookie so they have the same number of lines per page when they return to the site. You can also sort on any column.
__________________
Antec-SOLO | ASUS-P5Q-SE | C2D-E8600 | AC-Freezer-7-Pro | Seasonic-S12-550W | 3GB-KVR-PC2-6400 | GTX-560Ti | SB-XtremeGamer | Pioneer-BDR-205 | Samsung-S223B | Dell-U2412M
technoid is offline   Reply With Quote