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

php
mysql

#1

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.


#2

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