Query counts over 100,000 results in database but doenst return any actual rows
I wrote a basic php search engine (that searches a database of over 127,000 entries) that works absolutly fine until i enter a search keyword that returns over 100,000 results. It can count the results but doesn't display any data (return any rows). I'm wondering if mysql might have a maximum results limit or something thats making it bug out. I am already using a LIMIT 1, 5 so it only displays 5 results at time. Thanks in advance
Could be that you're exceeding the max packet size. See http://dev.mysql.com/doc/refman/5.0/...too-large.html for more info.
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
maybe you could also show us the query in question, you might have an error that's letting the count work but not the actual select search.
What happens when you use limit?
Edit: Stupid me, didn't notice that you already wrote that.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)