Anyone know what the command is to limit a query to 25 results for that page? I can't think of it right now so anyone who can help, it would be much appreciated.
i assume you mean from a database. if you are using mysql you just add "limit 25" to the end of your sql statement
Thats right it is from a DB. The ColdFusion statement grabs the info using the Get command and the where command to say what info to get would I put "limit 25" in the where info. so it says "where category= community limit 25"
yes so if you were asking select id from customer where name = 'mike' you could then change it to select id from customer where name = 'mike' limit 25
OK that helps. That was what I was thinking, Now How about limiting the next page to results 26-50? And so on and so forth.
i havent had to do that in a while but there is something that goes right before limit that tells the quesry where to begin, something like offset i can't remember
If this helps go to the aquarium site in my signature and take a look at the community fish page. I want to limit it to showing 25 results then have a next link for results 26 to 50. I would continue that pattern for all of the results. Thanks for your help with this, UndiesHosting.
Quick update on my question. I was able to search Google for tutorials on Offset and Limit in SQL. Thanks for the help.