Limit 5 records per page.
Each record has a membership fee
Need to add the total membership fees for those 5 records.
I am picturing having the table rows stop & then having 2 rows after the pagination rows. With the 5 table rows created on my page by the pagination script I am placing making the next row show totals for the selected records, but the last row will show totals for the entire database. I have that last row working, but can't seem to get the query code to total up just those 5 records that the pagination selected from the db.
I hope I haven't lost you.
Here is what I have now & it isn't working. The LIMIT $skip,$show is the same code that the pagination script uses in its processings.
$total_paid ="SELECT SUM(membership_fees) as membership_fees_paid FROM $membership_fees_table LIMIT $skip,$show";