not a valid MySQL result resource error????

Melville

On certain queries, I get the error message:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

This only occurs when there is a lot of data being returned. I believe it only happens when there are a lot of rows. I have trimmed down the amount of data for each row, but I still get the message at times.

I have looked at the result resource when it succeeds and when it fails. When it succeeds, the result resource is "#25", or some similar string, such as "#27". When it fails, it is also "#27". So I do not understand what is going on. I had the same error when I tried mysql_num_rows under the same circumstances.

Any suggestions?

Thank you very much,

Mel

laserlight

What is the error message returned from mysql_error()?

What is the table like?

Melville

I tried to print the error message. I checked mysql_error() after the select statement, and it was blank. I tried to check again after the call to mysql_fetch_array, but it died on the mysql_fetch_array call and never got to the error check. So I cannot tell you what the mysql error is other than:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

The result is still "#27", so it LOOKS like a valid result.

The table has more than 300 fields. The vast majority of these are 1-character flags. The bulk of the rest are integers and date fields. There are 46 varchar fields and 10 blobs.