Results 1 to 4 of 4
  1. #1
    Grandma broke her coccyx! Uncle Rico's Avatar
    Join Date
    May 8th, 2007
    Location
    North Carolina
    Posts
    2,238
    Mysql Problem on Select
    In a php script, I am running an sql query. When I run it against the table I get no results and I get the following error:

    supplied argument is not a valid MySQL result resource in

    At the same time, I echo the exact query to the screen so that I can copy it and run it in phpMyAdmin. When I run it there, I get no errors and it returns 136 records.

    Strange.

  2. #2
    Grandma broke her coccyx! Uncle Rico's Avatar
    Join Date
    May 8th, 2007
    Location
    North Carolina
    Posts
    2,238
    Actually, I think the problem may be with the # of rows returned from the select. I wonder if there is a max number of rows that can be returned at one time.

  3. #3
    Lite On The Do, Heavy On The Nuts Donuts's Avatar
    Join Date
    January 18th, 2005
    Location
    Winter Park, FL
    Posts
    6,930

  4. #4
    Grandma broke her coccyx! Uncle Rico's Avatar
    Join Date
    May 8th, 2007
    Location
    North Carolina
    Posts
    2,238
    Well, it's working now, but only after I limit the results using the "limit" command. I still want to understand if there is a max number of results that can be returned. It appears there is, but I would like to know what it is.

  5. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. I am Stumped with a PHP/MYSQL problem
    By Uncle Rico in forum Programming / Datafeeds / Tools
    Replies: 3
    Last Post: August 13th, 2010, 06:19 PM
  2. Using an array from a mysql field in a select statement
    By knight01 in forum Programming / Datafeeds / Tools
    Replies: 9
    Last Post: May 9th, 2010, 10:16 PM
  3. Update Mysql Table Using Inner Join Problem
    By Uncle Rico in forum Programming / Datafeeds / Tools
    Replies: 8
    Last Post: March 26th, 2009, 08:42 PM
  4. Multi Select
    By glittered in forum Commission Junction - CJ
    Replies: 0
    Last Post: January 28th, 2006, 07:20 PM
  5. MySQL Insert Data Problem - Help!
    By Taurus in forum Programming / Datafeeds / Tools
    Replies: 11
    Last Post: July 24th, 2002, 09:38 PM

Posting Permissions

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