Ok, I get it.
I can calculate the number of rows returned by subtracting the ->StartRow from the ->LastRow
The total rows calculation does not take into account the LIMIT keyword at all
With the offset, how do I return, (for example) records 5-8 from my table with MYSQLi ?