Is there a size or resource limit to result sets from MySQL?



I am getting empty results when I change the LIMIT clause from LIMIT 0,11 to LIMIT 0,12. It also seems to happen when I add extra columns. For example a LIMIT 0,20 works when I have fewer columns.

No errors are presented. Just seems to give an empty result set.

Pasting the same query into phpmyadmin works fine and returns the entire result set.


It was an error in JSON_encode() related to a particular entry in the database.