I still have some formatting to work on with the links. I was going to incorporate it into the Bootstrap pagination numbers at the very bottom. But I just wanted to test out and see how to do a pagination first and see if I could get it to work. The top 5 sections are what would show up when the user first clicks on the Press Release link. I have this set up as a library item in Dreamweaver so I can update this with the newest info, but if I get this pagination to work correctly, I think I won't need to use the library item and I can just pull the info. from the database.
Please look towards the bottom where the numbered list with the months and years are at. This is the pagination code I created that is coming from the SQL database. At first, the results show up perfect with Jan. 2018 being at the top since that's the newest. But if you click the next link it goes from 6-10 which is good, but the months and years don't change at all. Does anyone know why this is?
I was also having problems with limiting to only showing 5 results at a time because I couldn't get this line of code to work about limiting:
LIMIT #start_record#, #records_per_page# I was able to get this to work by putting maxrows="5" into the cfquery field like this:
I'm not sure if this is the correct way or not though. This is also where the Limit line was in the example above that I couldn't get to work. We are running SQL now too. I think I've read this is a SQL line of code.
I've added my code below and a screenshot of what I have in the database. Does anyone know how to get this to work with the correct info. displaying on each page and limiting to only having 5 records display at a time? Thanks.