|
Hi again.
I have a database with more than 20 results and am limiting the output to a page to 20. I can't get the logic right to make the second display page show the next 20 items because I can't use the _ID because the entries go into the database in a random number fashion. Here is the current code to display 20 items.
<cfquery name="BODYBUILDING" datasource="#db_datasource#" username="#db_username#" maxrows="20">
select *
FROM athlete
WHERE athlete_sport = 'BODY BUILDING'
order by athlete_surname ASC
</cfquery>
It seems to me that I might have to make another query that gathers all the _ID's from the database, and assigns them numbers and then get them to display in numerical order 20 per page.
Trouble with that is, how do I get the numbers in the first place, bearing in mind entries in Body Building may have _ID's like: 23, 47, 125, 228, 229, 314 and so on. The _ID's are given as people register which is totally at random. There are other sports also which have _ID's given to them, so my initial query must contain the name of the sport, in this case Body Building.
Any ideas how to get the next twenty ( a different 20) athletes, who are body builders to display?
Thnx, send any suggestion, I have the whole weekend to try and figure this out.
Ron... | 
IncrediMail - Email has finally evolved - Click Here
---