MySQLi wrong record count when using LIMIT keyword
I have a mySQLi recrdset from a table with 13 rows, but I added a LIMIT keyword so only the first 6 rows are returned,
This works, but if I add the server behavior 'MySQLi Display Total Records' , the value returned is 13, not 6