Results 1 to 4 of 4

Thread: Query counts over 100,000 results in database but doenst return any actual rows

  1. #1
    Join Date
    Jun 2005

    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

  2. #2
    Join Date
    Aug 2004
    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.
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

  3. #3
    Join Date
    Aug 2005
    The Garden State
    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.
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

  4. #4
    Join Date
    Jan 2005
    What happens when you use limit?

    Edit: Stupid me, didn't notice that you already wrote that.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center