www.webdeveloper.com
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
    Posts
    3

    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
    Location
    Ankh-Morpork
    Posts
    19,176
    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

    eBookworm.us

  3. #3
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    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
    Posts
    106
    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



Recent Articles